# Librerías
library(dplyr)
library(tidyr)
library(knitr)
library(readr)
library(ggplot2)
library(cowplot)
library(GGally)
laliga <- read_csv("combined_data_laliga.csv")
# primeros estadisticos de clase
str(laliga)
## spc_tbl_ [2,660 × 41] (S3: spec_tbl_df/tbl_df/tbl/data.frame)
## $ ...1 : num [1:2660] 0 1 2 3 4 5 6 7 8 9 ...
## $ Home Team : chr [1:2660] "MÁLAGA" "SEVILLA FC" "GRANADA" "ALMERÍA" ...
## $ Away Team : chr [1:2660] "ATHLETIC" "VALENCIA" "DEPORTIVO" "ESPANYOL" ...
## $ Score : chr [1:2660] "1-0" "1-1" "2-1" "1-1" ...
## $ Half Time Score : chr [1:2660] "1-0" "1-0" "0-1" "0-0" ...
## $ Match Excitement : num [1:2660] 4.4 4.7 4.6 5.6 3.7 5.1 7 4.7 4.7 2.1 ...
## $ Home Team Rating : num [1:2660] 6 6.5 7.2 6.9 6.5 8 7.3 5.6 6.9 6.9 ...
## $ Away Team Rating : num [1:2660] 5.7 6.8 5.9 5.5 5.9 5.3 5.5 7.3 5.5 5.9 ...
## $ Home Team Possession % : num [1:2660] 40 47 53 56 41 72 59 53 63 59 ...
## $ Away Team Possession % : num [1:2660] 60 53 47 44 59 28 41 47 37 41 ...
## $ Home Team Off Target Shots : num [1:2660] 5 4 6 7 5 5 4 4 3 5 ...
## $ Home Team On Target Shots : num [1:2660] 3 3 3 6 5 6 9 2 8 2 ...
## $ Home Team Total Shots : num [1:2660] 12 12 10 19 12 12 20 9 14 8 ...
## $ Home Team Blocked Shots : num [1:2660] 4 5 1 6 2 1 7 3 3 1 ...
## $ Home Team Corners : num [1:2660] 5 3 5 11 5 3 4 3 8 2 ...
## $ Home Team Throw Ins : num [1:2660] 13 20 25 26 28 23 21 16 25 23 ...
## $ Home Team Pass Success % : num [1:2660] 69 76 79 81 60 93 82 80 88 79 ...
## $ Home Team Aerials Won : num [1:2660] 11 13 20 19 29 2 27 19 23 21 ...
## $ Home Team Clearances : num [1:2660] 16 16 21 25 17 2 15 12 13 20 ...
## $ Home Team Fouls : num [1:2660] 13 23 13 8 13 11 19 11 9 13 ...
## $ Home Team Yellow Cards : num [1:2660] 3 4 1 3 4 0 4 1 1 2 ...
## $ Home Team Second Yellow Cards: num [1:2660] 0 0 0 0 0 0 0 0 0 0 ...
## $ Home Team Red Cards : num [1:2660] 2 0 0 0 0 1 0 0 0 0 ...
## $ Away Team Off Target Shots : num [1:2660] 5 5 1 6 7 3 8 5 6 3 ...
## $ Away Team On Target Shots : num [1:2660] 5 1 1 2 4 0 3 6 2 2 ...
## $ Away Team Total Shots : num [1:2660] 12 11 8 12 19 3 12 12 8 9 ...
## $ Away Team Blocked Shots : num [1:2660] 2 5 6 4 8 0 1 1 0 4 ...
## $ Away Team Corners : num [1:2660] 4 3 3 7 6 1 4 4 5 4 ...
## $ Away Team Throw Ins : num [1:2660] 22 27 30 19 36 19 19 14 18 34 ...
## $ Away Team Pass Success % : num [1:2660] 84 79 76 70 75 81 74 78 79 68 ...
## $ Away Team Aerials Won : num [1:2660] 17 14 10 11 25 4 22 21 15 26 ...
## $ Away Team Clearances : num [1:2660] 14 16 14 20 20 17 7 18 27 15 ...
## $ Away Team Fouls : num [1:2660] 9 8 26 9 14 13 15 14 13 17 ...
## $ Away Team Yellow Cards : num [1:2660] 3 2 3 3 1 1 1 3 2 2 ...
## $ Away Team Second Yellow Cards: num [1:2660] 0 0 0 1 0 0 0 0 0 0 ...
## $ Away Team Red Cards : num [1:2660] 0 1 0 0 0 0 0 0 0 0 ...
## $ Home Team Goals Scored : num [1:2660] 1 1 2 1 1 3 3 0 2 0 ...
## $ Away Team Goals Scored : num [1:2660] 0 1 1 1 0 0 1 2 0 0 ...
## $ Home Team Goals Conceeded : num [1:2660] 0 1 1 1 0 0 1 2 0 0 ...
## $ Away Team Goals Conceeded : num [1:2660] 1 1 2 1 1 3 3 0 2 0 ...
## $ year : num [1:2660] 2014 2014 2014 2014 2014 ...
## - attr(*, "spec")=
## .. cols(
## .. ...1 = col_double(),
## .. `Home Team` = col_character(),
## .. `Away Team` = col_character(),
## .. Score = col_character(),
## .. `Half Time Score` = col_character(),
## .. `Match Excitement` = col_double(),
## .. `Home Team Rating` = col_double(),
## .. `Away Team Rating` = col_double(),
## .. `Home Team Possession %` = col_double(),
## .. `Away Team Possession %` = col_double(),
## .. `Home Team Off Target Shots` = col_double(),
## .. `Home Team On Target Shots` = col_double(),
## .. `Home Team Total Shots` = col_double(),
## .. `Home Team Blocked Shots` = col_double(),
## .. `Home Team Corners` = col_double(),
## .. `Home Team Throw Ins` = col_double(),
## .. `Home Team Pass Success %` = col_double(),
## .. `Home Team Aerials Won` = col_double(),
## .. `Home Team Clearances` = col_double(),
## .. `Home Team Fouls` = col_double(),
## .. `Home Team Yellow Cards` = col_double(),
## .. `Home Team Second Yellow Cards` = col_double(),
## .. `Home Team Red Cards` = col_double(),
## .. `Away Team Off Target Shots` = col_double(),
## .. `Away Team On Target Shots` = col_double(),
## .. `Away Team Total Shots` = col_double(),
## .. `Away Team Blocked Shots` = col_double(),
## .. `Away Team Corners` = col_double(),
## .. `Away Team Throw Ins` = col_double(),
## .. `Away Team Pass Success %` = col_double(),
## .. `Away Team Aerials Won` = col_double(),
## .. `Away Team Clearances` = col_double(),
## .. `Away Team Fouls` = col_double(),
## .. `Away Team Yellow Cards` = col_double(),
## .. `Away Team Second Yellow Cards` = col_double(),
## .. `Away Team Red Cards` = col_double(),
## .. `Home Team Goals Scored` = col_double(),
## .. `Away Team Goals Scored` = col_double(),
## .. `Home Team Goals Conceeded` = col_double(),
## .. `Away Team Goals Conceeded` = col_double(),
## .. year = col_double()
## .. )
## - attr(*, "problems")=<externalptr>
summary(laliga) #medias y medianas son bastante similares, asi que se pueden analizar como normales
## ...1 Home Team Away Team Score
## Min. : 0.0 Length:2660 Length:2660 Length:2660
## 1st Qu.: 664.8 Class :character Class :character Class :character
## Median :1329.5 Mode :character Mode :character Mode :character
## Mean :1329.5
## 3rd Qu.:1994.2
## Max. :2659.0
## Half Time Score Match Excitement Home Team Rating Away Team Rating
## Length:2660 Min. : 1.400 Min. : 2.800 Min. : 3.000
## Class :character 1st Qu.: 3.900 1st Qu.: 5.700 1st Qu.: 5.400
## Mode :character Median : 5.100 Median : 6.400 Median : 6.000
## Mean : 5.249 Mean : 6.369 Mean : 6.045
## 3rd Qu.: 6.300 3rd Qu.: 6.900 3rd Qu.: 6.600
## Max. :10.000 Max. :10.000 Max. :10.000
## Home Team Possession % Away Team Possession % Home Team Off Target Shots
## Min. :18.00 Min. :17.00 Min. : 0.000
## 1st Qu.:44.00 1st Qu.:41.00 1st Qu.: 4.000
## Median :52.00 Median :48.00 Median : 5.000
## Mean :51.54 Mean :48.46 Mean : 5.533
## 3rd Qu.:59.00 3rd Qu.:56.00 3rd Qu.: 7.000
## Max. :83.00 Max. :82.00 Max. :18.000
## Home Team On Target Shots Home Team Total Shots Home Team Blocked Shots
## Min. : 0.000 Min. : 2.00 Min. : 0.000
## 1st Qu.: 3.000 1st Qu.:10.00 1st Qu.: 1.000
## Median : 4.000 Median :13.00 Median : 3.000
## Mean : 4.648 Mean :13.08 Mean : 2.913
## 3rd Qu.: 6.000 3rd Qu.:16.00 3rd Qu.: 4.000
## Max. :17.000 Max. :33.00 Max. :12.000
## Home Team Corners Home Team Throw Ins Home Team Pass Success %
## Min. : 0.000 Min. : 5.0 Min. :46.00
## 1st Qu.: 3.000 1st Qu.:18.0 1st Qu.:73.00
## Median : 5.000 Median :22.0 Median :78.00
## Mean : 5.395 Mean :22.5 Mean :77.71
## 3rd Qu.: 7.000 3rd Qu.:27.0 3rd Qu.:84.00
## Max. :20.000 Max. :49.0 Max. :93.00
## Home Team Aerials Won Home Team Clearances Home Team Fouls
## Min. : 2.0 Min. : 1.00 Min. : 1.00
## 1st Qu.:12.0 1st Qu.:12.00 1st Qu.:11.00
## Median :16.0 Median :17.00 Median :14.00
## Mean :17.1 Mean :17.71 Mean :13.75
## 3rd Qu.:22.0 3rd Qu.:22.00 3rd Qu.:16.00
## Max. :52.0 Max. :61.00 Max. :33.00
## Home Team Yellow Cards Home Team Second Yellow Cards Home Team Red Cards
## Min. :0.000 Min. :0.00000 Min. :0.00000
## 1st Qu.:1.000 1st Qu.:0.00000 1st Qu.:0.00000
## Median :2.000 Median :0.00000 Median :0.00000
## Mean :2.417 Mean :0.05602 Mean :0.04699
## 3rd Qu.:3.000 3rd Qu.:0.00000 3rd Qu.:0.00000
## Max. :8.000 Max. :2.00000 Max. :2.00000
## Away Team Off Target Shots Away Team On Target Shots Away Team Total Shots
## Min. : 0.00 Min. : 0.000 Min. : 0.00
## 1st Qu.: 3.00 1st Qu.: 2.000 1st Qu.: 7.00
## Median : 4.00 Median : 3.000 Median :10.00
## Mean : 4.32 Mean : 3.669 Mean :10.36
## 3rd Qu.: 6.00 3rd Qu.: 5.000 3rd Qu.:13.00
## Max. :14.00 Max. :13.000 Max. :28.00
## Away Team Blocked Shots Away Team Corners Away Team Throw Ins
## Min. : 0.000 Min. : 0.000 Min. : 3.00
## 1st Qu.: 1.000 1st Qu.: 2.000 1st Qu.:17.00
## Median : 2.000 Median : 4.000 Median :21.00
## Mean : 2.391 Mean : 4.215 Mean :21.48
## 3rd Qu.: 3.000 3rd Qu.: 6.000 3rd Qu.:26.00
## Max. :13.000 Max. :32.000 Max. :45.00
## Away Team Pass Success % Away Team Aerials Won Away Team Clearances
## Min. :41.0 Min. : 0.00 Min. : 1.00
## 1st Qu.:71.0 1st Qu.:11.00 1st Qu.:14.00
## Median :77.0 Median :16.00 Median :20.00
## Mean :75.9 Mean :16.75 Mean :21.43
## 3rd Qu.:82.0 3rd Qu.:21.00 3rd Qu.:27.00
## Max. :93.0 Max. :53.00 Max. :63.00
## Away Team Fouls Away Team Yellow Cards Away Team Second Yellow Cards
## Min. : 0.00 Min. :0.000 Min. :0.00000
## 1st Qu.:11.00 1st Qu.:2.000 1st Qu.:0.00000
## Median :13.00 Median :3.000 Median :0.00000
## Mean :13.77 Mean :2.641 Mean :0.07744
## 3rd Qu.:16.00 3rd Qu.:4.000 3rd Qu.:0.00000
## Max. :30.00 Max. :8.000 Max. :2.00000
## Away Team Red Cards Home Team Goals Scored Away Team Goals Scored
## Min. :0.00000 Min. : 0.000 Min. :0.000
## 1st Qu.:0.00000 1st Qu.: 1.000 1st Qu.:0.000
## Median :0.00000 Median : 1.000 Median :1.000
## Mean :0.04887 Mean : 1.518 Mean :1.141
## 3rd Qu.:0.00000 3rd Qu.: 2.000 3rd Qu.:2.000
## Max. :2.00000 Max. :10.000 Max. :8.000
## Home Team Goals Conceeded Away Team Goals Conceeded year
## Min. :0.000 Min. : 0.000 Min. :2014
## 1st Qu.:0.000 1st Qu.: 1.000 1st Qu.:2015
## Median :1.000 Median : 1.000 Median :2017
## Mean :1.141 Mean : 1.518 Mean :2017
## 3rd Qu.:2.000 3rd Qu.: 2.000 3rd Qu.:2019
## Max. :8.000 Max. :10.000 Max. :2020
El dataframe contiene todos los partidos de la liga española de 7
temporadas (de 2014 a 2020).
Home Team: Equipo local
Away Team: Equipo visitante
Score: Resultado
Half Time Score: Resultado al descanso
Match Excitement: Emoción del partido (subjetiva)
Home Team Rating: Nota del local (subjetiva)
Away Team Rating: Nota del visitante (subjetiva)
Home Team Possession: Posesión local
Away Team Possession: Posesión visitante
Home Team off Target Shots: Tiros fuera local
Home Team on Target Shots: Tiros a puerta local
Home Team Total Shots: Total tiros local
Home Team Blocked Shots: Tiros bloqueados local
Home Team Corners: Corners local
Home Team Throw Ins: Centros local
Home Team Pass Success: Pases exitosos local
Home Team Aerials Won: Balones aereos ganados
local
Home Team Clearences: Despejes local
Home Team Fouls: Faltas local
Home Team Yellow Cards: Amarillas local
Home Team Second Yellow Cards: Segundas amarillas
local
Home Team Red Cards: Rojas local
Away Team off Target Shots: Tiros fuera visitante
Away Team on Target Shots: Tiros a puerta
visitante
Away Team Total Shots: Total tiros visitante
Away Team Blocked Shots: Tiros bloqueados
visitante
Away Team Corners: Corners visitante
Away Team Throw Ins: Centros visitante
Away Team Pass Success: Pases exitosos visitante
Away Team Aerials Won: Balones aereos ganados
visitante
Away Team Clearences: Despejes visitante
Away Team Fouls: Faltas visitante
Away Team Yellow Cards: Amarillas visitante
Away Team Second Yellow Cards: Segundas amarillas
visitante
Away Team Red Cards: Rojas visitante
Home Team Goals Scored: Goles local
Away Team Goals Scored: Goles visitante
Home Team Goals Conceeded: Goles visitante
Away Team Goals Conceeded: Goles local
Year: Año
#Limpio los datos de las columnas quitando los espacios y cambiandolos por guiones, puesto que los espacios dan bastantes problemas a la hora de llamar a las variables
names(laliga) <- gsub(" ","_", names(laliga))
# Limpieza de variables que no nos interesan
laliga$Score <- NULL
laliga$`Half_Time_Score` <- NULL
laliga$`Match_Excitement` <- NULL
laliga$`Home_Team_Rating` <- NULL
laliga$`Away_Team_Rating` <- NULL
laliga$`Home_Team_Goals_Conceeded` <- NULL
laliga$`Away_Team_Goals_Conceeded` <- NULL
# Añadimos la columna resultado (tipo quiniela)
laliga <- mutate(laliga, resultado = ifelse(Home_Team_Goals_Scored-Away_Team_Goals_Scored > 0, "1",
ifelse(Home_Team_Goals_Scored-Away_Team_Goals_Scored < 0, "2", "x")))
# Añadimos la columna con los goles, tiros, tiros bloqueados, corners, centros, duelos aereos ganados, despejes, faltas, amarillas y rojas totales (por partido)
laliga <- mutate(laliga, goles = Home_Team_Goals_Scored + Away_Team_Goals_Scored)
laliga <- mutate(laliga, total_disparos = laliga$Home_Team_Total_Shots + laliga$Away_Team_Total_Shots)
laliga <- mutate(laliga, total_disparos_bloqueados = laliga$Home_Team_Blocked_Shots + laliga$Away_Team_Blocked_Shots)
laliga <- mutate(laliga, total_corners = laliga$Home_Team_Corners + laliga$Away_Team_Corners)
laliga <- mutate(laliga, total_centros = laliga$Home_Team_Throw_Ins + laliga$Away_Team_Throw_Ins)
laliga <- mutate(laliga, total_d_aereos = laliga$Home_Team_Aerials_Won + laliga$Away_Team_Aerials_Won)
laliga <- mutate(laliga, total_despejes = laliga$Home_Team_Clearances + laliga$Away_Team_Clearances)
laliga <- mutate(laliga, total_faltas = laliga$Home_Team_Fouls + laliga$Away_Team_Fouls)
laliga <- mutate(laliga, total_amarillas = laliga$Home_Team_Yellow_Cards + laliga$Away_Team_Yellow_Cards)
laliga <- mutate(laliga, total_rojas = laliga$Home_Team_Red_Cards + laliga$Away_Team_Red_Cards)
#Añadimos las columnas Home points y Away points
laliga <- mutate(laliga, Home_points = case_when(laliga$resultado == 1 ~ 3,
laliga$resultado == "x" ~ 1,
laliga$resultado == 2 ~ 0))
laliga <- mutate(laliga, Away_points = case_when(laliga$resultado == 1 ~ 0,
laliga$resultado == "x" ~ 1,
laliga$resultado == 2 ~ 3))
#añadimos una columna con la jornada
laliga <- mutate(laliga, jornada = ceiling(row_number() / 10)) %>%
mutate(jornada = (jornada - 1) %% 38 + 1)
# Convertimos a categorias
laliga$Home_Team <- as.factor(laliga$Home_Team)
laliga$Away_Team <- as.factor(laliga$Away_Team)
laliga$resultado <- as.factor(laliga$resultado)
# Dividimos los datos en dos datasets (train y test)
test <- filter(laliga, year==2020)
train <- filter(laliga, year<2020)
#write.csv(test,"test/test_laliga.csv")
#write.csv(train,"train/train_laliga.csv")
# dataframes separados por resultado
Victorias_casa <- train %>% filter(resultado==1)
Derrotas_casa <- train %>% filter(resultado==2)
Empates <- train %>% filter(resultado=="x")
train %>% select(25:35) %>%
ggpairs(aes(color = resultado, alpha = .5))
# de aqui sacamos los equipos que ha jugado cada equipo (más años en primera division)
as.data.frame(table(train$Home_Team) + table(train$Away_Team)) %>% arrange(desc(Freq))
## Var1 Freq
## 1 ATHLETIC 228
## 2 ATLETICO MADRID 228
## 3 BARCELONA 228
## 4 CELTA 228
## 5 EIBAR 228
## 6 ESPANYOL 228
## 7 REAL MADRID 228
## 8 REAL SOCIEDAD 228
## 9 SEVILLA FC 228
## 10 VALENCIA 228
## 11 VILLARREAL 228
## 12 GETAFE 190
## 13 LEVANTE 190
## 14 REAL BETIS 190
## 15 ALAVÉS 152
## 16 DEPORTIVO 152
## 17 GRANADA 152
## 18 LEGANÉS 152
## 19 MÁLAGA 152
## 20 LAS PALMAS 114
## 21 RAYO VALLECANO 114
## 22 GIJÓN 76
## 23 GIRONA 76
## 24 OSASUNA 76
## 25 VALLADOLID 76
## 26 ALMERÍA 38
## 27 CÓRDOBA 38
## 28 ELCHE 38
## 29 HUESCA 38
## 30 MALLORCA 38
## 31 CÁDIZ CF 0
# aqui vemos cuantos partidos han ganado, empatado y perdido cada equipo
with(train, table(Home_Team, resultado))
## resultado
## Home_Team 1 2 x
## ALAVÉS 30 23 23
## ALMERÍA 3 9 7
## ATHLETIC 56 24 34
## ATLETICO MADRID 82 9 23
## BARCELONA 94 7 13
## CÁDIZ CF 0 0 0
## CELTA 47 33 34
## CÓRDOBA 1 12 6
## DEPORTIVO 20 31 25
## EIBAR 48 42 24
## ELCHE 6 10 3
## ESPANYOL 46 37 31
## GETAFE 40 30 25
## GIJÓN 12 18 8
## GIRONA 11 18 9
## GRANADA 24 30 22
## HUESCA 5 8 6
## LAS PALMAS 21 23 13
## LEGANÉS 26 27 23
## LEVANTE 35 31 29
## MÁLAGA 30 29 17
## MALLORCA 8 8 3
## OSASUNA 9 15 14
## RAYO VALLECANO 21 24 12
## REAL BETIS 39 30 26
## REAL MADRID 86 12 16
## REAL SOCIEDAD 52 34 28
## SEVILLA FC 74 15 25
## VALENCIA 60 20 34
## VALLADOLID 10 13 15
## VILLARREAL 60 29 25
with(train, table(Away_Team, resultado))
## resultado
## Away_Team 1 2 x
## ALAVÉS 42 22 12
## ALMERÍA 13 5 1
## ATHLETIC 53 32 29
## ATLETICO MADRID 24 55 35
## BARCELONA 16 72 26
## CÁDIZ CF 0 0 0
## CELTA 58 26 30
## CÓRDOBA 12 2 5
## DEPORTIVO 37 9 30
## EIBAR 56 23 35
## ELCHE 9 5 5
## ESPANYOL 58 25 31
## GETAFE 45 23 27
## GIJÓN 22 5 11
## GIRONA 16 12 10
## GRANADA 46 13 17
## HUESCA 11 2 6
## LAS PALMAS 40 6 11
## LEGANÉS 44 13 19
## LEVANTE 57 18 20
## MÁLAGA 45 13 18
## MALLORCA 15 1 3
## OSASUNA 21 8 9
## RAYO VALLECANO 35 11 11
## REAL BETIS 51 24 20
## REAL MADRID 22 70 22
## REAL SOCIEDAD 53 34 27
## SEVILLA FC 48 37 29
## VALENCIA 48 37 29
## VALLADOLID 18 9 11
## VILLARREAL 41 39 34
#sacar porcentaje de victorias de cada equipo y ordenar por eso
#numero y proporcion de victorias, derrotas y empates
table(train$resultado)
##
## 1 2 x
## 1056 651 573
prop.table(table(train$resultado))
##
## 1 2 x
## 0.4631579 0.2855263 0.2513158
# victorias, derrotas y empates de cada equipo
with(train, table(resultado, Home_Team))
## Home_Team
## resultado ALAVÉS ALMERÍA ATHLETIC ATLETICO MADRID BARCELONA CÁDIZ CF CELTA
## 1 30 3 56 82 94 0 47
## 2 23 9 24 9 7 0 33
## x 23 7 34 23 13 0 34
## Home_Team
## resultado CÓRDOBA DEPORTIVO EIBAR ELCHE ESPANYOL GETAFE GIJÓN GIRONA GRANADA
## 1 1 20 48 6 46 40 12 11 24
## 2 12 31 42 10 37 30 18 18 30
## x 6 25 24 3 31 25 8 9 22
## Home_Team
## resultado HUESCA LAS PALMAS LEGANÉS LEVANTE MÁLAGA MALLORCA OSASUNA
## 1 5 21 26 35 30 8 9
## 2 8 23 27 31 29 8 15
## x 6 13 23 29 17 3 14
## Home_Team
## resultado RAYO VALLECANO REAL BETIS REAL MADRID REAL SOCIEDAD SEVILLA FC
## 1 21 39 86 52 74
## 2 24 30 12 34 15
## x 12 26 16 28 25
## Home_Team
## resultado VALENCIA VALLADOLID VILLARREAL
## 1 60 10 60
## 2 20 13 29
## x 34 15 25
# proporcion de victorias, derrotas y empates de cada equipo
t((prop.table(with(train, table(resultado, Home_Team)), margin = 2)))*100
## resultado
## Home_Team 1 2 x
## ALAVÉS 39.473684 30.263158 30.263158
## ALMERÍA 15.789474 47.368421 36.842105
## ATHLETIC 49.122807 21.052632 29.824561
## ATLETICO MADRID 71.929825 7.894737 20.175439
## BARCELONA 82.456140 6.140351 11.403509
## CÁDIZ CF
## CELTA 41.228070 28.947368 29.824561
## CÓRDOBA 5.263158 63.157895 31.578947
## DEPORTIVO 26.315789 40.789474 32.894737
## EIBAR 42.105263 36.842105 21.052632
## ELCHE 31.578947 52.631579 15.789474
## ESPANYOL 40.350877 32.456140 27.192982
## GETAFE 42.105263 31.578947 26.315789
## GIJÓN 31.578947 47.368421 21.052632
## GIRONA 28.947368 47.368421 23.684211
## GRANADA 31.578947 39.473684 28.947368
## HUESCA 26.315789 42.105263 31.578947
## LAS PALMAS 36.842105 40.350877 22.807018
## LEGANÉS 34.210526 35.526316 30.263158
## LEVANTE 36.842105 32.631579 30.526316
## MÁLAGA 39.473684 38.157895 22.368421
## MALLORCA 42.105263 42.105263 15.789474
## OSASUNA 23.684211 39.473684 36.842105
## RAYO VALLECANO 36.842105 42.105263 21.052632
## REAL BETIS 41.052632 31.578947 27.368421
## REAL MADRID 75.438596 10.526316 14.035088
## REAL SOCIEDAD 45.614035 29.824561 24.561404
## SEVILLA FC 64.912281 13.157895 21.929825
## VALENCIA 52.631579 17.543860 29.824561
## VALLADOLID 26.315789 34.210526 39.473684
## VILLARREAL 52.631579 25.438596 21.929825
10 equipos(Athletic, Atletico, Barcelona, Eibar, Espanyol, Real
Madrid, Real Sociedad, Sevilla, Valencia y Villarreal) han estado todas
las temporadas en primera.
# Posesion
summary(train$`Home_Team_Possession_%`)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 19.00 44.00 52.00 51.68 59.00 83.00
summary(train$`Away_Team_Possession_%`)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 17.00 41.00 48.00 48.32 56.00 81.00
# Tiros
summary(train$Home_Team_Off_Target_Shots)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 4.000 5.000 5.635 7.000 18.000
summary(train$Away_Team_Off_Target_Shots)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 3.000 4.000 4.336 6.000 14.000
summary(train$Home_Team_On_Target_Shots)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 3.000 4.000 4.757 6.000 17.000
summary(train$Away_Team_On_Target_Shots)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 2.000 3.000 3.708 5.000 13.000
summary(train$Home_Team_Total_Shots)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 2.00 10.00 13.00 13.36 16.00 33.00
summary(train$Away_Team_Total_Shots)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00 7.00 10.00 10.43 13.00 28.00
# Bloqueos
summary(train$Home_Team_Blocked_Shots)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 2.000 3.000 2.978 4.000 12.000
summary(train$Away_Team_Blocked_Shots)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 1.000 2.000 2.408 3.000 11.000
# Corners
summary(train$Home_Team_Corners)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 3.000 5.000 5.556 7.000 20.000
summary(train$Away_Team_Corners)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 2.000 4.000 4.202 6.000 32.000
# Centros
summary(train$Home_Team_Throw_Ins)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 5.00 18.00 22.00 22.76 27.00 49.00
summary(train$Away_Team_Throw_Ins)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 3.00 17.00 21.00 21.59 26.00 45.00
# Pases
summary(train$`Home_Team_Pass_Success_%`)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 46.00 73.00 78.00 77.64 83.00 93.00
summary(train$`Away_Team_Pass_Success_%`)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 41.0 71.0 77.0 75.7 82.0 93.0
# Balones aereos
summary(train$Home_Team_Aerials_Won)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 2.00 12.00 16.00 17.12 22.00 50.00
summary(train$Away_Team_Aerials_Won)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00 11.00 16.00 16.68 21.00 53.00
# Despejes
summary(train$Home_Team_Clearances)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 1.00 12.00 17.00 18.01 23.00 61.00
summary(train$Away_Team_Clearances)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 2.00 15.00 21.00 22.21 28.00 63.00
# Faltas
summary(train$Home_Team_Fouls)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 1.00 11.00 14.00 13.82 17.00 33.00
summary(train$Away_Team_Fouls)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00 11.00 14.00 13.86 17.00 30.00
# Amarillas
summary(train$Home_Team_Yellow_Cards)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 1.000 2.000 2.465 3.000 8.000
summary(train$Away_Team_Yellow_Cards)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 2.000 3.000 2.707 4.000 8.000
# Rojas
summary(train$Home_Team_Second_Yellow_Cards)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00000 0.00000 0.00000 0.05833 0.00000 2.00000
summary(train$Away_Team_Second_Yellow_Cards)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00000 0.00000 0.00000 0.08202 0.00000 2.00000
# Rojas
summary(train$Home_Team_Red_Cards)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00000 0.00000 0.00000 0.04561 0.00000 2.00000
summary(train$Away_Team_Red_Cards)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.00000 0.00000 0.00000 0.04868 0.00000 2.00000
# Goles
summary(train$goles)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 1.000 2.000 2.684 4.000 12.000
summary(train$goles)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 0.000 1.000 2.000 2.684 4.000 12.000
ggplot(train, aes(resultado, fill = resultado)) +
geom_bar() +
labs(x = "Resultado", y = "Nº de resultados", title = "Nº de victorias Local / Visitante / Empate") + theme(plot.title = element_text(hjust = 0.5))
# se ve que jugar en casa es un factor importante para ganar (aprox. la mitad de partidos los gana el de casa)
ggplot(train, aes(Home_Team)) + geom_bar() + ggtitle("Núm. prof. por categoría")
ggplot(train,aes(resultado ,goles)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'green') +
labs(title="Media de goles por partido", x="resultado", y="goles") +
theme(plot.title=element_text(hjust = 0.5))
# en los partidos con victorias locales hay más goles de media que en los que gana el visitante (y bastante más que en los que hay empate). Por tanto, un partido con más goles es más probable que no acabe en empate.
ggplot(train,aes(resultado ,Home_Team_Goals_Scored)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'green') +
labs(title="media de goles EQ. LOCAL por partido", x="resultado", y="goles local") +
theme(plot.title=element_text(hjust = 0.5))
# Cuando el equipo local gana, mayor es su media de goles. Es decir, a mas goles, mas victorias (obvio pero habia que comprobarlo)
ggplot(train,aes(resultado ,Away_Team_Goals_Scored)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'green') +
labs(title="media de goles EQ. VISITANTE por partido", x="resultado", y="goles visitante") +
theme(plot.title=element_text(hjust = 0.5))
# Cuando el equipo local pierde, mayor es la media de goles del visitante. Es decir, a mas goles encajados, mas derrotas (obvio pero habia que comprobarlo)
goles_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_goles = sum(goles)))
## Warning: `data_frame()` was deprecated in tibble 1.1.0.
## ℹ Please use `tibble()` instead.
tiros_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_tiros = sum(total_disparos)))
tiros_block_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_tiros_bloqueados = sum(total_disparos_bloqueados)))
corners_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_corners = sum(total_corners)))
centros_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_centros = sum(total_centros)))
d_aer_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_d_aer = sum(total_d_aereos)))
t_despj_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_despejes = sum(total_despejes)))
faltas_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_faltas = sum(total_faltas)))
amarll_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_amarillas = sum(total_amarillas)))
rojas_year_jorn <- data_frame(train %>% group_by(year, jornada) %>% summarise( total_rojas = sum(total_rojas)))
ggplot(goles_year_jorn, aes(x = jornada, y = total_goles)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de goles", title = "Nº de goles por jornada / Año") + theme(plot.title = element_text(hjust = 0.5)) + xlim(1,38)
ggplot(tiros_year_jorn, aes(x = jornada, y = total_tiros)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de disparos", title = "Nº de disparos por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(tiros_block_year_jorn, aes(x = jornada, y = total_tiros_bloqueados)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de disparos_bloqueados", title = "Nº de disparos bloqueados por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(corners_year_jorn, aes(x = jornada, y = total_corners)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de corners", title = "Nº de corners por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(centros_year_jorn, aes(x = jornada, y = total_centros)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de centros", title = "Nº de centros por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(t_despj_year_jorn, aes(x = jornada, y = total_despejes)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de despejes", title = "Nº de despejes por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(faltas_year_jorn, aes(x = jornada, y = total_faltas)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de faltas", title = "Nº de faltas por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(amarll_year_jorn, aes(x = jornada, y = total_amarillas)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de tarj. Amarillas", title = "Nº de tarj. Amarillas por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
ggplot(rojas_year_jorn, aes(x = jornada, y = total_rojas)) + geom_point() + facet_grid(~year) + labs(x = "jornadas", y = "Nº de tarj. Rojas", title = "Nº de tarj. Rojas por jornada / Año") + theme(plot.title = element_text(hjust = 0.5))
#Media de goles por partido
sum(train$Home_Team_Goals_Scored, train$Away_Team_Goals_Scored)/nrow(train)
## [1] 2.683772
#Media de goles por partido con victoria local
sum(Victorias_casa$Home_Team_Goals_Scored,Victorias_casa$Away_Team_Goals_Scored)/nrow(Victorias_casa)
## [1] 2.980114
#Media de goles por partido con victoria visitante
sum(Derrotas_casa$Home_Team_Goals_Scored,Derrotas_casa$Away_Team_Goals_Scored)/nrow(Derrotas_casa)
## [1] 2.826421
#Media de goles por partido con empate
sum(Empates$Home_Team_Goals_Scored,Empates$Away_Team_Goals_Scored)/nrow(Empates)
## [1] 1.975567
ggplot(train,aes(resultado , total_disparos)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'pink') +
labs(title="Media de disparos por partido", x="resultado", y="disparos") +
theme(plot.title=element_text(hjust = 0.5))
# en los partidos el numero total de disparos está bastante igualado con independencia de la victoria, derrota o empate.
ggplot(train,aes(resultado ,Home_Team_Total_Shots)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'pink') +
labs(title="media de tiros EQ. LOCAL por partido", x="resultado", y="tiros local") +
theme(plot.title=element_text(hjust = 0.5))
# El número de tiros no influye mucho en el resultado (gane, pierda o empate suelen ser similares)
ggplot(train,aes(resultado ,Home_Team_On_Target_Shots)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'pink') +
labs(title="media de tiros a puerta EQ. LOCAL por partido", x="resultado", y="tiros a puerta local") +
theme(plot.title=element_text(hjust = 0.5))
# Sin embargo el número de tiros a puerta si influye (cuantos más tiros a puerta, más cerca de la victoria)
ggplot(train,aes(resultado ,Away_Team_Total_Shots)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'pink') +
labs(title="media de tiros EQ. VISITANTE por partido", x="resultado", y="tiros local") +
theme(plot.title=element_text(hjust = 0.5))
# Igual que para el equipo local, el número de tiros no influye mucho en el resultado (gane, pierda o empate suelen ser similares)
ggplot(train,aes(resultado ,Away_Team_On_Target_Shots)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'pink') +
labs(title="media de tiros a puerta EQ. VISITANTE por partido", x="resultado", y="tiros a puerta local") +
theme(plot.title=element_text(hjust = 0.5))
# Sin embargo volvemos a ver que el número de tiros a puerta si influye (cuantos más tiros a puerta, más cerca de la victoria)
#Media de disparos por partido
sum(train$Home_Team_Total_Shots, train$Away_Team_Total_Shots)/nrow(train)
## [1] 23.79035
#Media de disparos a puerta partido
sum(train$Home_Team_On_Target_Shots, train$Away_Team_On_Target_Shots)/nrow(train)
## [1] 8.465351
#Media de disparos bloqueados
sum(train$Home_Team_Blocked_Shots, train$Away_Team_Blocked_Shots)/nrow(train)
## [1] 5.385965
ggplot(train,aes(resultado ,`Home_Team_Possession_%`)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'orange') +
labs(title="Gráfica Pep", x="resultado", y="posesion local") +
theme(plot.title=element_text(hjust = 0.5))
# No parece influir mucho la posesión
ggplot(train,aes(resultado ,`Away_Team_Possession_%`)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'orange') +
labs(title="Gráfica Pep", x="resultado", y="posesion visitante") +
theme(plot.title=element_text(hjust = 0.5))
# El equipo local suele tener más posesion (>50%) independientemente del resultado
ggplot(train,aes(resultado ,total_disparos_bloqueados)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = "grey") +
labs(title="Media de tiros bloqueados por partido", x="resultado", y="tiros bloqueados") +
theme(plot.title=element_text(hjust = 0.5))
# El numero de disparos bloqueados no parece un factor determinante en la victoria
ggplot(train,aes(resultado ,total_d_aereos)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = "brown") +
labs(title="Media de duelos aereos por partido", x="resultado", y="duelos aereos") +
theme(plot.title=element_text(hjust = 0.5))
# El numero de duelos aereos no parece un factor determinante en la victoria
ggplot(train,aes(resultado ,total_corners)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'blue') +
labs(title="Media de corners por partido", x="resultado", y="corners") +
theme(plot.title=element_text(hjust = 0.5))
# El numero de corners no parece un factor determinante en la victoria se puede observar como con independencia del ganadar el numero de corners está muy repartido
ggplot(train,aes(resultado ,total_centros)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'lightblue') +
labs(title="Media de centros por partido", x="resultado", y="centros") +
theme(plot.title=element_text(hjust = 0.5))
# El numero de centros no parece un factor determinante en la victoria se puede observar como con independencia del ganadar el numero de centros está muy repartido
ggplot(train,aes(resultado ,total_despejes)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'lightgreen') +
labs(title="Media de despejes por partido", x="resultado", y="despejes") +
theme(plot.title=element_text(hjust = 0.5))
# El numero de despejes no parece un factor determinante en la victoria incluso parece que a mayor número de despejes medios el partido parece más probable que acabe en empate
ggplot(train,aes(resultado ,total_faltas)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'lightyellow') +
labs(title="Media de faltas por partido", x="resultado", y="faltas") +
theme(plot.title=element_text(hjust = 0.5))
# El numero de faltas no parece un factor determinante.
ggplot(train,aes(resultado ,total_amarillas)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'yellow') +
labs(title="Media de amarillas por partido", x="resultado", y="amarillas") +
theme(plot.title=element_text(hjust = 0.5))
# El numero de tarjetas amarillas no parece un factor determinante.
ggplot(train,aes(resultado ,total_rojas)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'red') +
labs(title="Media de rojas por partido", x="resultado", y="rojas") +
theme(plot.title=element_text(hjust = 0.5))
# El numero de tarjetas rojas no parece un factor determinante.
#Puntos promedio por partido por equipo
puntos_promedio_casa <- aggregate((Home_points) ~ Home_Team, data = train, mean)
puntos_promedio_fuera <- aggregate(Away_points ~ Away_Team, data = train, mean)
puntos_promedio <- data.frame(puntos_promedio_casa$Home_Team, (puntos_promedio_casa$`(Home_points)` + puntos_promedio_fuera$Away_points)/2)
names(puntos_promedio) <- c("Equipo", "Puntos_por_partido")
puntos_promedio
## Equipo Puntos_por_partido
## 1 ALAVÉS 1.2565789
## 2 ALMERÍA 0.8421053
## 3 ATHLETIC 1.4342105
## 4 ATLETICO MADRID 2.0570175
## 5 BARCELONA 2.3552632
## 6 CELTA 1.2412281
## 7 CÓRDOBA 0.5263158
## 8 DEPORTIVO 0.9342105
## 9 EIBAR 1.1929825
## 10 ELCHE 1.0789474
## 11 ESPANYOL 1.2061404
## 12 GETAFE 1.2684211
## 13 GIJÓN 0.9210526
## 14 GIRONA 1.1578947
## 15 GRANADA 0.9868421
## 16 HUESCA 0.8684211
## 17 LAS PALMAS 0.9210526
## 18 LEGANÉS 1.0460526
## 19 LEVANTE 1.0947368
## 20 MÁLAGA 1.0789474
## 21 MALLORCA 0.8684211
## 22 OSASUNA 0.9736842
## 23 RAYO VALLECANO 1.0438596
## 24 REAL BETIS 1.2368421
## 25 REAL MADRID 2.2192982
## 26 REAL SOCIEDAD 1.3728070
## 27 SEVILLA FC 1.6973684
## 28 VALENCIA 1.5526316
## 29 VALLADOLID 1.0921053
## 30 VILLARREAL 1.5614035
#Esta seria la clasificacion con la media de puntos por partido por equipo
clasificacion_media <- arrange(puntos_promedio,desc(Puntos_por_partido))
clasificacion_media
## Equipo Puntos_por_partido
## 1 BARCELONA 2.3552632
## 2 REAL MADRID 2.2192982
## 3 ATLETICO MADRID 2.0570175
## 4 SEVILLA FC 1.6973684
## 5 VILLARREAL 1.5614035
## 6 VALENCIA 1.5526316
## 7 ATHLETIC 1.4342105
## 8 REAL SOCIEDAD 1.3728070
## 9 GETAFE 1.2684211
## 10 ALAVÉS 1.2565789
## 11 CELTA 1.2412281
## 12 REAL BETIS 1.2368421
## 13 ESPANYOL 1.2061404
## 14 EIBAR 1.1929825
## 15 GIRONA 1.1578947
## 16 LEVANTE 1.0947368
## 17 VALLADOLID 1.0921053
## 18 ELCHE 1.0789474
## 19 MÁLAGA 1.0789474
## 20 LEGANÉS 1.0460526
## 21 RAYO VALLECANO 1.0438596
## 22 GRANADA 0.9868421
## 23 OSASUNA 0.9736842
## 24 DEPORTIVO 0.9342105
## 25 GIJÓN 0.9210526
## 26 LAS PALMAS 0.9210526
## 27 HUESCA 0.8684211
## 28 MALLORCA 0.8684211
## 29 ALMERÍA 0.8421053
## 30 CÓRDOBA 0.5263158
aggregate(Home_Team_Goals_Scored ~ Home_Team, data = train, FUN = mean) -> goles_home_team
goles_home_team
## Home_Team Home_Team_Goals_Scored
## 1 ALAVÉS 1.0394737
## 2 ALMERÍA 1.0526316
## 3 ATHLETIC 1.4473684
## 4 ATLETICO MADRID 1.7982456
## 5 BARCELONA 3.0789474
## 6 CELTA 1.5438596
## 7 CÓRDOBA 0.6315789
## 8 DEPORTIVO 1.2631579
## 9 EIBAR 1.3771930
## 10 ELCHE 1.0000000
## 11 ESPANYOL 1.1929825
## 12 GETAFE 1.2421053
## 13 GIJÓN 1.4210526
## 14 GIRONA 1.1315789
## 15 GRANADA 1.0789474
## 16 HUESCA 1.2631579
## 17 LAS PALMAS 1.2807018
## 18 LEGANÉS 1.0131579
## 19 LEVANTE 1.3578947
## 20 MÁLAGA 1.2894737
## 21 MALLORCA 1.3157895
## 22 OSASUNA 1.2894737
## 23 RAYO VALLECANO 1.4035088
## 24 REAL BETIS 1.4000000
## 25 REAL MADRID 2.7105263
## 26 REAL SOCIEDAD 1.6140351
## 27 SEVILLA FC 1.8508772
## 28 VALENCIA 1.6491228
## 29 VALLADOLID 0.8947368
## 30 VILLARREAL 1.6666667
aggregate(Away_Team_Goals_Scored ~ Away_Team, data = train, FUN = mean) -> goles_Away_team
goles_Away_team
## Away_Team Away_Team_Goals_Scored
## 1 ALAVÉS 0.9868421
## 2 ALMERÍA 0.7894737
## 3 ATHLETIC 0.9736842
## 4 ATLETICO MADRID 1.3947368
## 5 BARCELONA 2.2982456
## 6 CELTA 1.0877193
## 7 CÓRDOBA 0.5263158
## 8 DEPORTIVO 0.8552632
## 9 EIBAR 0.9736842
## 10 ELCHE 0.8421053
## 11 ESPANYOL 0.9736842
## 12 GETAFE 0.8947368
## 13 GIJÓN 0.7368421
## 14 GIRONA 1.1578947
## 15 GRANADA 0.9868421
## 16 HUESCA 1.0000000
## 17 LAS PALMAS 0.8596491
## 18 LEGANÉS 0.7894737
## 19 LEVANTE 0.9684211
## 20 MÁLAGA 0.7236842
## 21 MALLORCA 0.7894737
## 22 OSASUNA 0.9736842
## 23 RAYO VALLECANO 1.0350877
## 24 REAL BETIS 0.9894737
## 25 REAL MADRID 2.2105263
## 26 REAL SOCIEDAD 1.1491228
## 27 SEVILLA FC 1.2719298
## 28 VALENCIA 1.2807018
## 29 VALLADOLID 0.7894737
## 30 VILLARREAL 1.1140351
goles_por_equipo <- data.frame(goles_home_team$Home_Team,(goles_Away_team$Away_Team_Goals_Scored + goles_home_team$Home_Team_Goals_Scored)/2)
names(goles_por_equipo) <- c("equipo", "goles")
goles_por_equipo
## equipo goles
## 1 ALAVÉS 1.0131579
## 2 ALMERÍA 0.9210526
## 3 ATHLETIC 1.2105263
## 4 ATLETICO MADRID 1.5964912
## 5 BARCELONA 2.6885965
## 6 CELTA 1.3157895
## 7 CÓRDOBA 0.5789474
## 8 DEPORTIVO 1.0592105
## 9 EIBAR 1.1754386
## 10 ELCHE 0.9210526
## 11 ESPANYOL 1.0833333
## 12 GETAFE 1.0684211
## 13 GIJÓN 1.0789474
## 14 GIRONA 1.1447368
## 15 GRANADA 1.0328947
## 16 HUESCA 1.1315789
## 17 LAS PALMAS 1.0701754
## 18 LEGANÉS 0.9013158
## 19 LEVANTE 1.1631579
## 20 MÁLAGA 1.0065789
## 21 MALLORCA 1.0526316
## 22 OSASUNA 1.1315789
## 23 RAYO VALLECANO 1.2192982
## 24 REAL BETIS 1.1947368
## 25 REAL MADRID 2.4605263
## 26 REAL SOCIEDAD 1.3815789
## 27 SEVILLA FC 1.5614035
## 28 VALENCIA 1.4649123
## 29 VALLADOLID 0.8421053
## 30 VILLARREAL 1.3903509
#No he sido capaz de poner encima una grafica de densidad con los puntos de cada equipo
ggplot(goles_por_equipo, aes(x = equipo, y = goles)) +
geom_bar(position = "dodge", stat = "summary", fill = "darkred") +
labs(title = "Comparación goles y puntos") +
theme(plot.title = element_text(hjust = 0.5), axis.text.x = element_text(angle = 90))
#Porcentaje medio de posesión por equipo en casa
tapply(train$`Home_Team_Possession_%`,train$`Home_Team`,mean)
## ALAVÉS ALMERÍA ATHLETIC ATLETICO MADRID BARCELONA
## 43.86842 45.42105 51.60526 50.35965 66.31579
## CÁDIZ CF CELTA CÓRDOBA DEPORTIVO EIBAR
## NA 56.37719 51.47368 49.11842 50.61404
## ELCHE ESPANYOL GETAFE GIJÓN GIRONA
## 50.05263 48.02632 44.64211 45.89474 49.52632
## GRANADA HUESCA LAS PALMAS LEGANÉS LEVANTE
## 46.69737 47.31579 58.73684 45.60526 46.25263
## MÁLAGA MALLORCA OSASUNA RAYO VALLECANO REAL BETIS
## 48.85526 42.89474 45.47368 54.57895 55.57895
## REAL MADRID REAL SOCIEDAD SEVILLA FC VALENCIA VALLADOLID
## 60.01754 55.49123 56.39474 49.71930 47.60526
## VILLARREAL
## 51.55263
#Porcentaje medio de posesión por equipo fuera de casa
tapply(train$`Away_Team_Possession_%`,train$`Away_Team`,mean)
## ALAVÉS ALMERÍA ATHLETIC ATLETICO MADRID BARCELONA
## 39.93421 42.31579 48.71930 46.68421 66.14035
## CÁDIZ CF CELTA CÓRDOBA DEPORTIVO EIBAR
## NA 52.42105 41.21053 45.23684 45.45614
## ELCHE ESPANYOL GETAFE GIJÓN GIRONA
## 44.89474 44.92105 41.80000 41.42105 45.44737
## GRANADA HUESCA LAS PALMAS LEGANÉS LEVANTE
## 42.86842 41.21053 53.70175 41.26316 43.56842
## MÁLAGA MALLORCA OSASUNA RAYO VALLECANO REAL BETIS
## 46.07895 46.15789 40.94737 53.59649 53.07368
## REAL MADRID REAL SOCIEDAD SEVILLA FC VALENCIA VALLADOLID
## 57.20175 52.43860 51.73684 48.09649 43.36842
## VILLARREAL
## 46.90351
summary(Empates$`Home_Team_Possession_%`)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 21.00 45.00 52.00 51.69 59.00 81.00
summary(Victorias_casa$`Home_Team_Possession_%`)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 22.00 44.00 52.00 52.18 60.00 83.00
summary(Derrotas_casa$`Home_Team_Possession_%`)
## Min. 1st Qu. Median Mean 3rd Qu. Max.
## 19.00 43.00 52.00 50.86 59.00 80.00
#Con estos datos tan similares sacamos en conclusión que la posesión no ha influido mucho en las victorias(pobre Pep)
ggplot(train,aes(Home_Team ,Home_Team_Goals_Scored)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'red') +
labs(title="media de goles de cada equipo como local", x="equipos", y="goles por partido") +
theme(plot.title=element_text(hjust = 0.5), axis.text = element_text(angle = 90, color = "darkblue"))
# media de goles por partido de cada equipo en su casa
ggplot(train,aes(Away_Team ,Away_Team_Goals_Scored)) +
geom_bar(position = "dodge", stat = "summary", fun = "mean",
color = 'black', fill = 'red') +
labs(title="media de goles de cada equipo como visitante", x="equipos", y="goles por partido") +
theme(plot.title=element_text(hjust = 0.5), axis.text = element_text(angle = 90, color = "darkblue"))
# Los equipos que más goles meten por partido, son los que más temporadas han estado en primera
# Correlación de algunas variables
pairs(train %>%
select(Home_Team_Goals_Scored, Home_Team_On_Target_Shots, Home_Team_Total_Shots, `Home_Team_Possession_%`, `Home_Team_Pass_Success_%`, Home_Team_Corners, Home_Team_Throw_Ins, Home_Team_Fouls, Home_Team_Aerials_Won), pch = 21, bg = "black", col = "red")
hist(train$Home_Team_Goals_Scored,breaks=15, main = "Histograma de goles en casa",
xlab = "goles")
hist(train$Away_Team_Goals_Scored,breaks=15, main = "Histograma de goles fuera",
xlab = "goles")
# Se marcan más goles en casa que fuera
lm_fit <- lm(Home_Team_Goals_Scored~.-Home_Team, data=train)
summary(lm_fit)
##
## Call:
## lm(formula = Home_Team_Goals_Scored ~ . - Home_Team, data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4.052e-13 -1.160e-15 -1.000e-16 1.130e-15 3.480e-14
##
## Coefficients: (12 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.150e-10 5.625e-11 2.044e+00 0.041048 *
## ...1 1.510e-16 7.349e-17 2.055e+00 0.039968 *
## Away_TeamALMERÍA 7.287e-16 2.592e-15 2.810e-01 0.778640
## Away_TeamATHLETIC -4.605e-15 1.493e-15 -3.085e+00 0.002063 **
## Away_TeamATLETICO MADRID -3.750e-15 1.511e-15 -2.482e+00 0.013148 *
## Away_TeamBARCELONA -1.503e-15 1.716e-15 -8.760e-01 0.381244
## Away_TeamCELTA -2.346e-16 1.516e-15 -1.550e-01 0.877048
## Away_TeamCÓRDOBA 2.938e-15 2.590e-15 1.134e+00 0.256818
## Away_TeamDEPORTIVO -9.851e-16 1.650e-15 -5.970e-01 0.550600
## Away_TeamEIBAR -1.359e-15 1.506e-15 -9.020e-01 0.367139
## Away_TeamELCHE 2.069e-16 2.593e-15 8.000e-02 0.936403
## Away_TeamESPANYOL -7.988e-16 1.482e-15 -5.390e-01 0.589906
## Away_TeamGETAFE -1.356e-15 1.556e-15 -8.710e-01 0.383718
## Away_TeamGIJÓN -1.636e-16 2.000e-15 -8.200e-02 0.934841
## Away_TeamGIRONA 1.410e-15 1.980e-15 7.120e-01 0.476511
## Away_TeamGRANADA 5.790e-16 1.628e-15 3.560e-01 0.722171
## Away_TeamHUESCA 6.078e-17 2.537e-15 2.400e-02 0.980886
## Away_TeamLAS PALMAS -5.086e-16 1.819e-15 -2.800e-01 0.779795
## Away_TeamLEGANÉS -4.437e-15 1.613e-15 -2.751e+00 0.005997 **
## Away_TeamLEVANTE 1.681e-15 1.538e-15 1.093e+00 0.274468
## Away_TeamMÁLAGA -1.605e-15 1.644e-15 -9.770e-01 0.328917
## Away_TeamMALLORCA 3.999e-16 2.556e-15 1.560e-01 0.875703
## Away_TeamOSASUNA 1.689e-16 1.977e-15 8.500e-02 0.931927
## Away_TeamRAYO VALLECANO -2.834e-16 1.803e-15 -1.570e-01 0.875124
## Away_TeamREAL BETIS 1.418e-15 1.588e-15 8.930e-01 0.372198
## Away_TeamREAL MADRID -6.567e-15 1.621e-15 -4.051e+00 5.28e-05 ***
## Away_TeamREAL SOCIEDAD -6.484e-16 1.511e-15 -4.290e-01 0.667830
## Away_TeamSEVILLA FC 7.016e-17 1.514e-15 4.600e-02 0.963044
## Away_TeamVALENCIA -2.210e-15 1.508e-15 -1.466e+00 0.142907
## Away_TeamVALLADOLID 1.740e-15 1.984e-15 8.770e-01 0.380358
## Away_TeamVILLARREAL -1.148e-15 1.508e-15 -7.620e-01 0.446262
## `Home_Team_Possession_%` 5.866e-17 6.998e-17 8.380e-01 0.401979
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots 4.472e-16 1.157e-15 3.870e-01 0.699104
## Home_Team_On_Target_Shots -7.787e-16 1.157e-15 -6.730e-01 0.501134
## Home_Team_Total_Shots -4.398e-16 1.152e-15 -3.820e-01 0.702666
## Home_Team_Blocked_Shots 3.852e-16 1.154e-15 3.340e-01 0.738525
## Home_Team_Corners 3.317e-16 9.442e-17 3.512e+00 0.000453 ***
## Home_Team_Throw_Ins 8.677e-17 4.063e-17 2.136e+00 0.032824 *
## `Home_Team_Pass_Success_%` 8.475e-17 7.603e-17 1.115e+00 0.265133
## Home_Team_Aerials_Won -5.296e-17 4.073e-17 -1.300e+00 0.193637
## Home_Team_Clearances 1.003e-16 3.662e-17 2.740e+00 0.006195 **
## Home_Team_Fouls 8.670e-17 5.964e-17 1.454e+00 0.146188
## Home_Team_Yellow_Cards -7.367e-17 1.549e-16 -4.750e-01 0.634518
## Home_Team_Second_Yellow_Cards -1.269e-15 8.858e-16 -1.433e+00 0.152134
## Home_Team_Red_Cards -1.075e-14 9.565e-16 -1.124e+01 < 2e-16 ***
## Away_Team_Off_Target_Shots 1.030e-15 9.973e-16 1.033e+00 0.301856
## Away_Team_On_Target_Shots 4.665e-16 1.001e-15 4.660e-01 0.641402
## Away_Team_Total_Shots -8.472e-16 9.938e-16 -8.520e-01 0.394052
## Away_Team_Blocked_Shots 9.657e-16 1.002e-15 9.640e-01 0.335233
## Away_Team_Corners 1.313e-16 1.039e-16 1.264e+00 0.206402
## Away_Team_Throw_Ins 1.916e-17 4.310e-17 4.440e-01 0.656779
## `Away_Team_Pass_Success_%` -1.313e-17 7.312e-17 -1.800e-01 0.857500
## Away_Team_Aerials_Won -8.572e-18 4.228e-17 -2.030e-01 0.839330
## Away_Team_Clearances -6.803e-18 3.273e-17 -2.080e-01 0.835353
## Away_Team_Fouls 6.010e-17 5.844e-17 1.028e+00 0.303842
## Away_Team_Yellow_Cards 1.795e-16 1.566e-16 1.146e+00 0.251947
## Away_Team_Second_Yellow_Cards 8.531e-16 7.606e-16 1.122e+00 0.262148
## Away_Team_Red_Cards 1.337e-15 9.431e-16 1.418e+00 0.156358
## Away_Team_Goals_Scored -1.000e+00 4.823e-16 -2.073e+15 < 2e-16 ***
## year -5.710e-14 2.793e-14 -2.045e+00 0.041009 *
## resultado2 -6.183e-16 9.637e-16 -6.420e-01 0.521185
## resultadox -2.141e-16 6.805e-16 -3.150e-01 0.753066
## goles 1.000e+00 2.701e-16 3.702e+15 < 2e-16 ***
## total_disparos NA NA NA NA
## total_disparos_bloqueados NA NA NA NA
## total_corners NA NA NA NA
## total_centros NA NA NA NA
## total_d_aereos NA NA NA NA
## total_despejes NA NA NA NA
## total_faltas NA NA NA NA
## total_amarillas NA NA NA NA
## total_rojas NA NA NA NA
## Home_points NA NA NA NA
## Away_points NA NA NA NA
## jornada -1.439e-15 7.351e-16 -1.958e+00 0.050373 .
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 9.83e-15 on 2216 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 6.715e+29 on 63 and 2216 DF, p-value: < 2.2e-16
#regfit_fwd <- leaps::regsubsets(Home_Team_Goals_Scored~., train, method="forward")
#for (metric in c("r2", "adjr2", "Cp", "bic")){plot(regfit_fwd, scale=metric)}
Variables más influyentes en los goles marcados: Centros, despejes,
tarjetas rojas,
prop.table(table(Victorias_casa$Home_Team_Total_Shots > Victorias_casa$Away_Team_Total_Shots))
##
## FALSE TRUE
## 0.3001894 0.6998106
#En un 30% de las victorias de casa el equipo de casa tiró menos tiros que el de fuera
prop.table(table(Victorias_casa$Home_Team_Blocked_Shots > Victorias_casa$Away_Team_Blocked_Shots))
##
## FALSE TRUE
## 0.5246212 0.4753788
#Los tiros bloqueados no influyen mucho en el resultado del partido
prop.table(table(Derrotas_casa$Home_Team_Blocked_Shots > Derrotas_casa$Away_Team_Blocked_Shots))
##
## FALSE TRUE
## 0.437788 0.562212
#En las derrotas si vemos que el 43% de las veces bloquearon menos
Regrsión con todas las variables
lm_goles <- lm(goles~., data = train)
summary(lm_goles)
##
## Call:
## lm(formula = goles ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4.252e-14 -1.180e-15 1.100e-16 1.310e-15 3.978e-13
##
## Coefficients: (12 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -1.037e-10 5.655e-11 -1.834e+00 0.066848 .
## ...1 -1.363e-16 7.388e-17 -1.846e+00 0.065091 .
## Home_TeamALMERÍA -9.591e-16 2.590e-15 -3.700e-01 0.711142
## Home_TeamATHLETIC -3.738e-16 1.497e-15 -2.500e-01 0.802835
## Home_TeamATLETICO MADRID 3.007e-16 1.515e-15 1.990e-01 0.842660
## Home_TeamBARCELONA -2.144e-15 1.760e-15 -1.218e+00 0.223285
## Home_TeamCELTA -9.547e-16 1.542e-15 -6.190e-01 0.535914
## Home_TeamCÓRDOBA -2.002e-15 2.592e-15 -7.720e-01 0.439992
## Home_TeamDEPORTIVO 7.998e-16 1.645e-15 4.860e-01 0.626772
## Home_TeamEIBAR -4.925e-16 1.526e-15 -3.230e-01 0.746983
## Home_TeamELCHE -2.960e-15 2.597e-15 -1.140e+00 0.254555
## Home_TeamESPANYOL -2.478e-15 1.482e-15 -1.672e+00 0.094599 .
## Home_TeamGETAFE -2.851e-15 1.560e-15 -1.827e+00 0.067830 .
## Home_TeamGIJÓN -4.155e-15 2.014e-15 -2.063e+00 0.039226 *
## Home_TeamGIRONA -5.397e-16 1.980e-15 -2.730e-01 0.785226
## Home_TeamGRANADA -9.466e-16 1.625e-15 -5.820e-01 0.560375
## Home_TeamHUESCA 1.180e-15 2.545e-15 4.640e-01 0.642900
## Home_TeamLAS PALMAS -5.480e-15 1.855e-15 -2.954e+00 0.003171 **
## Home_TeamLEGANÉS -1.753e-15 1.611e-15 -1.089e+00 0.276446
## Home_TeamLEVANTE -1.458e-15 1.546e-15 -9.430e-01 0.345638
## Home_TeamMÁLAGA 5.077e-15 1.641e-15 3.094e+00 0.002002 **
## Home_TeamMALLORCA -1.474e-15 2.555e-15 -5.770e-01 0.564009
## Home_TeamOSASUNA -3.709e-16 1.991e-15 -1.860e-01 0.852266
## Home_TeamRAYO VALLECANO -4.176e-15 1.805e-15 -2.314e+00 0.020782 *
## Home_TeamREAL BETIS -2.062e-15 1.598e-15 -1.290e+00 0.197184
## Home_TeamREAL MADRID -1.046e-15 1.673e-15 -6.250e-01 0.532040
## Home_TeamREAL SOCIEDAD 3.737e-16 1.526e-15 2.450e-01 0.806617
## Home_TeamSEVILLA FC -1.665e-16 1.550e-15 -1.070e-01 0.914460
## Home_TeamVALENCIA -1.680e-16 1.521e-15 -1.110e-01 0.912015
## Home_TeamVALLADOLID 1.864e-15 1.993e-15 9.350e-01 0.349727
## Home_TeamVILLARREAL -1.648e-15 1.522e-15 -1.083e+00 0.278961
## Away_TeamALMERÍA 9.205e-15 2.588e-15 3.557e+00 0.000383 ***
## Away_TeamATHLETIC 3.958e-15 1.498e-15 2.642e+00 0.008308 **
## Away_TeamATLETICO MADRID -8.607e-16 1.516e-15 -5.680e-01 0.570196
## Away_TeamBARCELONA 5.579e-16 1.768e-15 3.160e-01 0.752331
## Away_TeamCELTA 6.818e-16 1.523e-15 4.480e-01 0.654362
## Away_TeamCÓRDOBA 4.133e-16 2.589e-15 1.600e-01 0.873206
## Away_TeamDEPORTIVO 1.370e-15 1.650e-15 8.310e-01 0.406202
## Away_TeamEIBAR 2.817e-15 1.513e-15 1.862e+00 0.062729 .
## Away_TeamELCHE -2.987e-15 2.589e-15 -1.154e+00 0.248629
## Away_TeamESPANYOL 1.309e-15 1.481e-15 8.840e-01 0.376749
## Away_TeamGETAFE 3.797e-16 1.557e-15 2.440e-01 0.807336
## Away_TeamGIJÓN 3.729e-16 1.996e-15 1.870e-01 0.851829
## Away_TeamGIRONA 2.581e-16 1.978e-15 1.300e-01 0.896183
## Away_TeamGRANADA 1.627e-15 1.625e-15 1.001e+00 0.316792
## Away_TeamHUESCA -5.483e-16 2.532e-15 -2.170e-01 0.828593
## Away_TeamLAS PALMAS 4.558e-15 1.825e-15 2.497e+00 0.012588 *
## Away_TeamLEGANÉS -7.124e-16 1.610e-15 -4.420e-01 0.658262
## Away_TeamLEVANTE 2.478e-15 1.536e-15 1.613e+00 0.106850
## Away_TeamMÁLAGA -7.302e-16 1.643e-15 -4.440e-01 0.656785
## Away_TeamMALLORCA 4.265e-15 2.552e-15 1.671e+00 0.094851 .
## Away_TeamOSASUNA -9.294e-16 1.974e-15 -4.710e-01 0.637826
## Away_TeamRAYO VALLECANO 3.447e-15 1.807e-15 1.908e+00 0.056577 .
## Away_TeamREAL BETIS 2.295e-15 1.596e-15 1.438e+00 0.150706
## Away_TeamREAL MADRID 2.442e-15 1.648e-15 1.482e+00 0.138554
## Away_TeamREAL SOCIEDAD 2.615e-15 1.521e-15 1.719e+00 0.085709 .
## Away_TeamSEVILLA FC 2.029e-15 1.521e-15 1.334e+00 0.182380
## Away_TeamVALENCIA 2.030e-15 1.512e-15 1.343e+00 0.179491
## Away_TeamVALLADOLID 8.160e-16 1.979e-15 4.120e-01 0.680191
## Away_TeamVILLARREAL 2.426e-15 1.511e-15 1.606e+00 0.108421
## `Home_Team_Possession_%` 2.661e-16 7.675e-17 3.467e+00 0.000537 ***
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots -5.490e-17 1.160e-15 -4.700e-02 0.962264
## Home_Team_On_Target_Shots 8.129e-16 1.160e-15 7.010e-01 0.483655
## Home_Team_Total_Shots 1.966e-16 1.155e-15 1.700e-01 0.864902
## Home_Team_Blocked_Shots -4.294e-16 1.157e-15 -3.710e-01 0.710587
## Home_Team_Corners -1.787e-16 9.541e-17 -1.873e+00 0.061268 .
## Home_Team_Throw_Ins 1.039e-16 4.171e-17 2.490e+00 0.012842 *
## `Home_Team_Pass_Success_%` -1.984e-16 8.174e-17 -2.428e+00 0.015282 *
## Home_Team_Aerials_Won 1.748e-18 4.342e-17 4.000e-02 0.967898
## Home_Team_Clearances -7.912e-17 3.698e-17 -2.139e+00 0.032523 *
## Home_Team_Fouls -4.362e-17 6.077e-17 -7.180e-01 0.472930
## Home_Team_Yellow_Cards 4.599e-17 1.560e-16 2.950e-01 0.768092
## Home_Team_Second_Yellow_Cards 6.128e-17 8.899e-16 6.900e-02 0.945103
## Home_Team_Red_Cards 6.101e-15 9.652e-16 6.321e+00 3.14e-10 ***
## Away_Team_Off_Target_Shots 5.597e-16 9.965e-16 5.620e-01 0.574360
## Away_Team_On_Target_Shots 1.487e-15 1.001e-15 1.486e+00 0.137365
## Away_Team_Total_Shots -6.901e-16 9.931e-16 -6.950e-01 0.487226
## Away_Team_Blocked_Shots 6.828e-16 1.001e-15 6.820e-01 0.495242
## Away_Team_Corners -6.942e-17 1.044e-16 -6.650e-01 0.506168
## Away_Team_Throw_Ins 4.391e-18 4.458e-17 9.800e-02 0.921561
## `Away_Team_Pass_Success_%` 1.144e-16 7.615e-17 1.502e+00 0.133206
## Away_Team_Aerials_Won 2.425e-17 4.290e-17 5.650e-01 0.571987
## Away_Team_Clearances -2.391e-16 3.404e-17 -7.023e+00 2.90e-12 ***
## Away_Team_Fouls -1.750e-16 6.009e-17 -2.913e+00 0.003616 **
## Away_Team_Yellow_Cards 1.858e-16 1.586e-16 1.171e+00 0.241533
## Away_Team_Second_Yellow_Cards 4.049e-16 7.679e-16 5.270e-01 0.598062
## Away_Team_Red_Cards -3.413e-16 9.455e-16 -3.610e-01 0.718154
## Home_Team_Goals_Scored 1.000e+00 2.730e-16 3.663e+15 < 2e-16 ***
## Away_Team_Goals_Scored 1.000e+00 3.085e-16 3.242e+15 < 2e-16 ***
## year 5.149e-14 2.808e-14 1.834e+00 0.066819 .
## resultado2 -1.171e-15 9.729e-16 -1.204e+00 0.228794
## resultadox -6.430e-16 6.855e-16 -9.380e-01 0.348277
## total_disparos NA NA NA NA
## total_disparos_bloqueados NA NA NA NA
## total_corners NA NA NA NA
## total_centros NA NA NA NA
## total_d_aereos NA NA NA NA
## total_despejes NA NA NA NA
## total_faltas NA NA NA NA
## total_amarillas NA NA NA NA
## total_rojas NA NA NA NA
## Home_points NA NA NA NA
## Away_points NA NA NA NA
## jornada 1.324e-15 7.390e-16 1.792e+00 0.073343 .
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 9.794e-15 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 7.5e+29 on 92 and 2187 DF, p-value: < 2.2e-16
lm_disparos <- lm(total_disparos~., data = train)
summary(lm_disparos)
##
## Call:
## lm(formula = total_disparos ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.785e-13 -1.070e-14 4.200e-15 1.890e-14 6.871e-12
##
## Coefficients: (12 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -1.903e-09 8.797e-10 -2.164e+00 0.03061 *
## ...1 -2.497e-15 1.149e-15 -2.173e+00 0.02989 *
## Home_TeamALMERÍA -2.646e-14 4.029e-14 -6.570e-01 0.51138
## Home_TeamATHLETIC -2.397e-15 2.329e-14 -1.030e-01 0.91805
## Home_TeamATLETICO MADRID -8.469e-15 2.357e-14 -3.590e-01 0.71934
## Home_TeamBARCELONA -2.508e-14 2.738e-14 -9.160e-01 0.35977
## Home_TeamCELTA -7.377e-15 2.399e-14 -3.080e-01 0.75847
## Home_TeamCÓRDOBA -8.556e-16 4.032e-14 -2.100e-02 0.98307
## Home_TeamDEPORTIVO -4.844e-15 2.558e-14 -1.890e-01 0.84986
## Home_TeamEIBAR -9.743e-15 2.374e-14 -4.100e-01 0.68160
## Home_TeamELCHE -1.443e-14 4.040e-14 -3.570e-01 0.72109
## Home_TeamESPANYOL -3.681e-16 2.305e-14 -1.600e-02 0.98726
## Home_TeamGETAFE -1.341e-14 2.427e-14 -5.520e-01 0.58072
## Home_TeamGIJÓN -2.070e-14 3.133e-14 -6.610e-01 0.50891
## Home_TeamGIRONA 1.272e-15 3.080e-14 4.100e-02 0.96707
## Home_TeamGRANADA -1.049e-14 2.529e-14 -4.150e-01 0.67818
## Home_TeamHUESCA -3.849e-15 3.960e-14 -9.700e-02 0.92257
## Home_TeamLAS PALMAS -5.839e-15 2.886e-14 -2.020e-01 0.83967
## Home_TeamLEGANÉS -1.105e-14 2.506e-14 -4.410e-01 0.65937
## Home_TeamLEVANTE -1.694e-14 2.405e-14 -7.040e-01 0.48142
## Home_TeamMÁLAGA 7.941e-14 2.553e-14 3.111e+00 0.00189 **
## Home_TeamMALLORCA -4.440e-18 3.974e-14 0.000e+00 0.99991
## Home_TeamOSASUNA -5.090e-15 3.098e-14 -1.640e-01 0.86951
## Home_TeamRAYO VALLECANO -1.262e-14 2.808e-14 -4.490e-01 0.65315
## Home_TeamREAL BETIS -3.354e-15 2.487e-14 -1.350e-01 0.89272
## Home_TeamREAL MADRID -1.843e-14 2.603e-14 -7.080e-01 0.47888
## Home_TeamREAL SOCIEDAD -3.037e-15 2.374e-14 -1.280e-01 0.89822
## Home_TeamSEVILLA FC -7.815e-15 2.411e-14 -3.240e-01 0.74582
## Home_TeamVALENCIA -5.715e-15 2.366e-14 -2.420e-01 0.80911
## Home_TeamVALLADOLID 2.032e-15 3.100e-14 6.600e-02 0.94774
## Home_TeamVILLARREAL -6.956e-15 2.368e-14 -2.940e-01 0.76896
## Away_TeamALMERÍA 1.617e-15 4.026e-14 4.000e-02 0.96797
## Away_TeamATHLETIC 5.872e-14 2.331e-14 2.519e+00 0.01184 *
## Away_TeamATLETICO MADRID -1.423e-15 2.358e-14 -6.000e-02 0.95189
## Away_TeamBARCELONA -2.422e-14 2.750e-14 -8.810e-01 0.37858
## Away_TeamCELTA -7.690e-15 2.369e-14 -3.250e-01 0.74546
## Away_TeamCÓRDOBA -1.514e-14 4.028e-14 -3.760e-01 0.70706
## Away_TeamDEPORTIVO -4.149e-15 2.566e-14 -1.620e-01 0.87156
## Away_TeamEIBAR -6.707e-15 2.353e-14 -2.850e-01 0.77567
## Away_TeamELCHE -2.436e-14 4.027e-14 -6.050e-01 0.54529
## Away_TeamESPANYOL -5.490e-15 2.303e-14 -2.380e-01 0.81164
## Away_TeamGETAFE -3.163e-15 2.422e-14 -1.310e-01 0.89612
## Away_TeamGIJÓN 1.061e-15 3.105e-14 3.400e-02 0.97275
## Away_TeamGIRONA -4.658e-15 3.076e-14 -1.510e-01 0.87965
## Away_TeamGRANADA -6.892e-15 2.528e-14 -2.730e-01 0.78515
## Away_TeamHUESCA -2.759e-15 3.939e-14 -7.000e-02 0.94416
## Away_TeamLAS PALMAS -1.222e-14 2.839e-14 -4.300e-01 0.66691
## Away_TeamLEGANÉS -3.420e-15 2.505e-14 -1.370e-01 0.89143
## Away_TeamLEVANTE -1.425e-14 2.389e-14 -5.970e-01 0.55089
## Away_TeamMÁLAGA -6.897e-16 2.556e-14 -2.700e-02 0.97848
## Away_TeamMALLORCA 2.873e-15 3.970e-14 7.200e-02 0.94231
## Away_TeamOSASUNA 9.386e-15 3.071e-14 3.060e-01 0.75990
## Away_TeamRAYO VALLECANO -6.155e-15 2.811e-14 -2.190e-01 0.82669
## Away_TeamREAL BETIS -1.280e-14 2.483e-14 -5.160e-01 0.60616
## Away_TeamREAL MADRID 1.362e-14 2.564e-14 5.310e-01 0.59520
## Away_TeamREAL SOCIEDAD 2.650e-15 2.366e-14 1.120e-01 0.91084
## Away_TeamSEVILLA FC -6.062e-15 2.367e-14 -2.560e-01 0.79789
## Away_TeamVALENCIA -4.382e-15 2.352e-14 -1.860e-01 0.85224
## Away_TeamVALLADOLID -1.185e-14 3.079e-14 -3.850e-01 0.70048
## Away_TeamVILLARREAL -8.914e-15 2.350e-14 -3.790e-01 0.70449
## `Home_Team_Possession_%` 1.559e-15 1.194e-15 1.305e+00 0.19186
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots -6.887e-16 1.805e-14 -3.800e-02 0.96957
## Home_Team_On_Target_Shots -3.796e-15 1.805e-14 -2.100e-01 0.83345
## Home_Team_Total_Shots 1.000e+00 1.797e-14 5.563e+13 < 2e-16 ***
## Home_Team_Blocked_Shots -4.680e-16 1.800e-14 -2.600e-02 0.97926
## Home_Team_Corners -2.029e-16 1.484e-15 -1.370e-01 0.89126
## Home_Team_Throw_Ins -1.111e-15 6.488e-16 -1.712e+00 0.08697 .
## `Home_Team_Pass_Success_%` -2.275e-15 1.272e-15 -1.789e+00 0.07375 .
## Home_Team_Aerials_Won -2.163e-16 6.754e-16 -3.200e-01 0.74885
## Home_Team_Clearances -3.969e-16 5.753e-16 -6.900e-01 0.49030
## Home_Team_Fouls -7.746e-16 9.454e-16 -8.190e-01 0.41270
## Home_Team_Yellow_Cards 1.138e-15 2.426e-15 4.690e-01 0.63914
## Home_Team_Second_Yellow_Cards 1.409e-15 1.384e-14 1.020e-01 0.91893
## Home_Team_Red_Cards 1.360e-13 1.502e-14 9.060e+00 < 2e-16 ***
## Away_Team_Off_Target_Shots -2.766e-15 1.550e-14 -1.780e-01 0.85839
## Away_Team_On_Target_Shots 2.079e-15 1.557e-14 1.340e-01 0.89375
## Away_Team_Total_Shots 1.000e+00 1.545e-14 6.473e+13 < 2e-16 ***
## Away_Team_Blocked_Shots -8.861e-16 1.557e-14 -5.700e-02 0.95463
## Away_Team_Corners -5.089e-16 1.624e-15 -3.130e-01 0.75405
## Away_Team_Throw_Ins -2.886e-16 6.936e-16 -4.160e-01 0.67738
## `Away_Team_Pass_Success_%` 1.269e-15 1.185e-15 1.072e+00 0.28397
## Away_Team_Aerials_Won 7.110e-17 6.673e-16 1.070e-01 0.91516
## Away_Team_Clearances -4.433e-16 5.296e-16 -8.370e-01 0.40266
## Away_Team_Fouls -1.323e-15 9.348e-16 -1.415e+00 0.15710
## Away_Team_Yellow_Cards 6.105e-16 2.467e-15 2.470e-01 0.80458
## Away_Team_Second_Yellow_Cards -4.817e-15 1.194e-14 -4.030e-01 0.68682
## Away_Team_Red_Cards -1.416e-14 1.471e-14 -9.630e-01 0.33574
## Home_Team_Goals_Scored -3.459e-15 4.247e-15 -8.150e-01 0.41542
## Away_Team_Goals_Scored -3.047e-15 4.799e-15 -6.350e-01 0.52555
## year 9.451e-13 4.368e-13 2.164e+00 0.03059 *
## resultado2 -2.460e-14 1.514e-14 -1.626e+00 0.10420
## resultadox -1.661e-14 1.066e-14 -1.557e+00 0.11951
## goles NA NA NA NA
## total_disparos_bloqueados NA NA NA NA
## total_corners NA NA NA NA
## total_centros NA NA NA NA
## total_d_aereos NA NA NA NA
## total_despejes NA NA NA NA
## total_faltas NA NA NA NA
## total_amarillas NA NA NA NA
## total_rojas NA NA NA NA
## Home_points NA NA NA NA
## Away_points NA NA NA NA
## jornada 2.442e-14 1.150e-14 2.124e+00 0.03377 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.524e-13 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 3.438e+28 on 92 and 2187 DF, p-value: < 2.2e-16
lm_disparos_bloqueados <- lm(total_disparos_bloqueados~., data = train)
summary(lm_disparos_bloqueados)
##
## Call:
## lm(formula = total_disparos_bloqueados ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.926e-12 -5.730e-15 -1.550e-15 3.330e-15 4.481e-13
##
## Coefficients: (12 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 5.499e-10 2.534e-10 2.170e+00 0.03011 *
## ...1 7.215e-16 3.310e-16 2.179e+00 0.02941 *
## Home_TeamALMERÍA 5.015e-16 1.160e-14 4.300e-02 0.96553
## Home_TeamATHLETIC 2.654e-15 6.708e-15 3.960e-01 0.69242
## Home_TeamATLETICO MADRID 3.393e-15 6.788e-15 5.000e-01 0.61728
## Home_TeamBARCELONA 6.123e-15 7.888e-15 7.760e-01 0.43764
## Home_TeamCELTA 4.945e-15 6.910e-15 7.160e-01 0.47433
## Home_TeamCÓRDOBA 2.290e-15 1.161e-14 1.970e-01 0.84369
## Home_TeamDEPORTIVO 4.009e-15 7.369e-15 5.440e-01 0.58653
## Home_TeamEIBAR 7.048e-15 6.839e-15 1.030e+00 0.30290
## Home_TeamELCHE 5.040e-15 1.164e-14 4.330e-01 0.66503
## Home_TeamESPANYOL 4.324e-15 6.641e-15 6.510e-01 0.51498
## Home_TeamGETAFE 5.901e-15 6.991e-15 8.440e-01 0.39876
## Home_TeamGIJÓN 6.560e-15 9.024e-15 7.270e-01 0.46730
## Home_TeamGIRONA 3.139e-15 8.873e-15 3.540e-01 0.72357
## Home_TeamGRANADA 4.713e-15 7.284e-15 6.470e-01 0.51770
## Home_TeamHUESCA 3.025e-15 1.141e-14 2.650e-01 0.79088
## Home_TeamLAS PALMAS 2.301e-16 8.312e-15 2.800e-02 0.97792
## Home_TeamLEGANÉS 1.148e-14 7.218e-15 1.590e+00 0.11201
## Home_TeamLEVANTE 7.010e-15 6.928e-15 1.012e+00 0.31173
## Home_TeamMÁLAGA -1.792e-14 7.354e-15 -2.436e+00 0.01492 *
## Home_TeamMALLORCA 4.449e-15 1.145e-14 3.890e-01 0.69763
## Home_TeamOSASUNA 4.948e-15 8.923e-15 5.550e-01 0.57929
## Home_TeamRAYO VALLECANO 7.925e-15 8.088e-15 9.800e-01 0.32728
## Home_TeamREAL BETIS 7.033e-15 7.163e-15 9.820e-01 0.32628
## Home_TeamREAL MADRID 9.773e-15 7.498e-15 1.303e+00 0.19256
## Home_TeamREAL SOCIEDAD 4.661e-15 6.839e-15 6.820e-01 0.49561
## Home_TeamSEVILLA FC 3.988e-15 6.944e-15 5.740e-01 0.56583
## Home_TeamVALENCIA 2.810e-15 6.814e-15 4.120e-01 0.68012
## Home_TeamVALLADOLID -1.200e-15 8.930e-15 -1.340e-01 0.89313
## Home_TeamVILLARREAL 5.904e-15 6.821e-15 8.660e-01 0.38684
## Away_TeamALMERÍA 1.064e-15 1.160e-14 9.200e-02 0.92693
## Away_TeamATHLETIC -1.929e-14 6.714e-15 -2.873e+00 0.00411 **
## Away_TeamATLETICO MADRID -1.581e-15 6.792e-15 -2.330e-01 0.81600
## Away_TeamBARCELONA 2.014e-15 7.921e-15 2.540e-01 0.79926
## Away_TeamCELTA -1.616e-15 6.823e-15 -2.370e-01 0.81281
## Away_TeamCÓRDOBA 4.536e-15 1.160e-14 3.910e-01 0.69588
## Away_TeamDEPORTIVO -1.852e-15 7.392e-15 -2.510e-01 0.80218
## Away_TeamEIBAR -7.241e-15 6.779e-15 -1.068e+00 0.28553
## Away_TeamELCHE 4.637e-16 1.160e-14 4.000e-02 0.96811
## Away_TeamESPANYOL -2.852e-15 6.635e-15 -4.300e-01 0.66732
## Away_TeamGETAFE -5.203e-15 6.977e-15 -7.460e-01 0.45591
## Away_TeamGIJÓN -1.265e-15 8.944e-15 -1.410e-01 0.88757
## Away_TeamGIRONA -2.007e-15 8.861e-15 -2.260e-01 0.82084
## Away_TeamGRANADA 1.555e-17 7.282e-15 2.000e-03 0.99830
## Away_TeamHUESCA -5.168e-15 1.135e-14 -4.550e-01 0.64884
## Away_TeamLAS PALMAS -3.735e-16 8.179e-15 -4.600e-02 0.96358
## Away_TeamLEGANÉS -4.141e-15 7.216e-15 -5.740e-01 0.56612
## Away_TeamLEVANTE 2.750e-16 6.883e-15 4.000e-02 0.96813
## Away_TeamMÁLAGA -3.472e-15 7.363e-15 -4.720e-01 0.63732
## Away_TeamMALLORCA -4.206e-15 1.144e-14 -3.680e-01 0.71303
## Away_TeamOSASUNA -4.316e-15 8.845e-15 -4.880e-01 0.62562
## Away_TeamRAYO VALLECANO -7.268e-16 8.097e-15 -9.000e-02 0.92849
## Away_TeamREAL BETIS 3.179e-15 7.153e-15 4.440e-01 0.65674
## Away_TeamREAL MADRID -1.064e-15 7.385e-15 -1.440e-01 0.88544
## Away_TeamREAL SOCIEDAD -3.482e-15 6.815e-15 -5.110e-01 0.60947
## Away_TeamSEVILLA FC 1.255e-15 6.818e-15 1.840e-01 0.85396
## Away_TeamVALENCIA 1.025e-15 6.776e-15 1.510e-01 0.87973
## Away_TeamVALLADOLID 2.010e-15 8.870e-15 2.270e-01 0.82078
## Away_TeamVILLARREAL 8.887e-16 6.770e-15 1.310e-01 0.89557
## `Home_Team_Possession_%` -2.463e-16 3.439e-16 -7.160e-01 0.47390
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots 7.212e-15 5.199e-15 1.387e+00 0.16556
## Home_Team_On_Target_Shots 7.502e-15 5.200e-15 1.443e+00 0.14927
## Home_Team_Total_Shots -7.080e-15 5.178e-15 -1.367e+00 0.17163
## Home_Team_Blocked_Shots 1.000e+00 5.185e-15 1.929e+14 < 2e-16 ***
## Home_Team_Corners -2.459e-16 4.275e-16 -5.750e-01 0.56522
## Home_Team_Throw_Ins 3.361e-16 1.869e-16 1.799e+00 0.07221 .
## `Home_Team_Pass_Success_%` 4.790e-16 3.663e-16 1.308e+00 0.19114
## Home_Team_Aerials_Won 1.835e-18 1.946e-16 9.000e-03 0.99248
## Home_Team_Clearances 5.415e-17 1.657e-16 3.270e-01 0.74392
## Home_Team_Fouls 1.160e-16 2.723e-16 4.260e-01 0.67029
## Home_Team_Yellow_Cards -1.610e-16 6.989e-16 -2.300e-01 0.81787
## Home_Team_Second_Yellow_Cards -5.309e-17 3.988e-15 -1.300e-02 0.98938
## Home_Team_Red_Cards -3.914e-14 4.325e-15 -9.048e+00 < 2e-16 ***
## Away_Team_Off_Target_Shots -2.100e-15 4.465e-15 -4.700e-01 0.63823
## Away_Team_On_Target_Shots -2.781e-15 4.484e-15 -6.200e-01 0.53512
## Away_Team_Total_Shots 2.332e-15 4.450e-15 5.240e-01 0.60025
## Away_Team_Blocked_Shots 1.000e+00 4.486e-15 2.229e+14 < 2e-16 ***
## Away_Team_Corners 1.212e-16 4.679e-16 2.590e-01 0.79564
## Away_Team_Throw_Ins -2.279e-17 1.998e-16 -1.140e-01 0.90918
## `Away_Team_Pass_Success_%` -3.832e-16 3.412e-16 -1.123e+00 0.26157
## Away_Team_Aerials_Won -9.635e-18 1.922e-16 -5.000e-02 0.96003
## Away_Team_Clearances 1.675e-16 1.525e-16 1.098e+00 0.27242
## Away_Team_Fouls 4.707e-16 2.693e-16 1.748e+00 0.08058 .
## Away_Team_Yellow_Cards -4.989e-16 7.106e-16 -7.020e-01 0.48271
## Away_Team_Second_Yellow_Cards 1.377e-15 3.441e-15 4.000e-01 0.68902
## Away_Team_Red_Cards 3.133e-15 4.237e-15 7.390e-01 0.45971
## Home_Team_Goals_Scored 1.216e-15 1.223e-15 9.940e-01 0.32044
## Away_Team_Goals_Scored 1.202e-15 1.382e-15 8.700e-01 0.38464
## year -2.731e-13 1.258e-13 -2.170e+00 0.03009 *
## resultado2 6.006e-15 4.360e-15 1.378e+00 0.16850
## resultadox 5.268e-15 3.072e-15 1.715e+00 0.08650 .
## goles NA NA NA NA
## total_disparos NA NA NA NA
## total_corners NA NA NA NA
## total_centros NA NA NA NA
## total_d_aereos NA NA NA NA
## total_despejes NA NA NA NA
## total_faltas NA NA NA NA
## total_amarillas NA NA NA NA
## total_rojas NA NA NA NA
## Home_points NA NA NA NA
## Away_points NA NA NA NA
## jornada -7.076e-15 3.311e-15 -2.137e+00 0.03272 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 4.389e-14 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 8.752e+28 on 92 and 2187 DF, p-value: < 2.2e-16
lm_corners <- lm(total_corners~., data = train)
summary(lm_corners)
##
## Call:
## lm(formula = total_corners ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -3.206e-12 -9.000e-15 -2.200e-15 5.200e-15 2.392e-13
##
## Coefficients: (12 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 9.505e-10 4.120e-10 2.307e+00 0.02115 *
## ...1 1.248e-15 5.383e-16 2.319e+00 0.02048 *
## Home_TeamALMERÍA 1.194e-15 1.887e-14 6.300e-02 0.94957
## Home_TeamATHLETIC 1.213e-15 1.091e-14 1.110e-01 0.91149
## Home_TeamATLETICO MADRID 2.922e-15 1.104e-14 2.650e-01 0.79120
## Home_TeamBARCELONA 9.535e-15 1.282e-14 7.430e-01 0.45728
## Home_TeamCELTA 4.547e-15 1.123e-14 4.050e-01 0.68574
## Home_TeamCÓRDOBA -2.775e-16 1.888e-14 -1.500e-02 0.98828
## Home_TeamDEPORTIVO 6.664e-16 1.198e-14 5.600e-02 0.95565
## Home_TeamEIBAR 3.006e-15 1.112e-14 2.700e-01 0.78697
## Home_TeamELCHE 2.951e-15 1.892e-14 1.560e-01 0.87609
## Home_TeamESPANYOL 1.359e-15 1.080e-14 1.260e-01 0.89987
## Home_TeamGETAFE 9.281e-15 1.137e-14 8.160e-01 0.41431
## Home_TeamGIJÓN 5.420e-15 1.467e-14 3.690e-01 0.71187
## Home_TeamGIRONA -2.779e-15 1.443e-14 -1.930e-01 0.84727
## Home_TeamGRANADA 3.610e-15 1.184e-14 3.050e-01 0.76053
## Home_TeamHUESCA -5.105e-15 1.855e-14 -2.750e-01 0.78314
## Home_TeamLAS PALMAS 6.283e-16 1.352e-14 4.600e-02 0.96293
## Home_TeamLEGANÉS 2.634e-15 1.174e-14 2.240e-01 0.82242
## Home_TeamLEVANTE 6.078e-15 1.126e-14 5.400e-01 0.58954
## Home_TeamMÁLAGA -3.625e-14 1.196e-14 -3.032e+00 0.00246 **
## Home_TeamMALLORCA 5.773e-15 1.861e-14 3.100e-01 0.75649
## Home_TeamOSASUNA 2.648e-15 1.451e-14 1.820e-01 0.85521
## Home_TeamRAYO VALLECANO 5.360e-15 1.315e-14 4.080e-01 0.68365
## Home_TeamREAL BETIS 3.260e-15 1.165e-14 2.800e-01 0.77955
## Home_TeamREAL MADRID 4.905e-15 1.219e-14 4.020e-01 0.68743
## Home_TeamREAL SOCIEDAD 1.815e-15 1.112e-14 1.630e-01 0.87036
## Home_TeamSEVILLA FC 3.926e-15 1.129e-14 3.480e-01 0.72803
## Home_TeamVALENCIA 9.348e-16 1.108e-14 8.400e-02 0.93276
## Home_TeamVALLADOLID -4.173e-15 1.452e-14 -2.870e-01 0.77384
## Home_TeamVILLARREAL 4.499e-15 1.109e-14 4.060e-01 0.68500
## Away_TeamALMERÍA 1.049e-14 1.885e-14 5.560e-01 0.57813
## Away_TeamATHLETIC -2.360e-14 1.092e-14 -2.162e+00 0.03074 *
## Away_TeamATLETICO MADRID 1.437e-15 1.104e-14 1.300e-01 0.89649
## Away_TeamBARCELONA 9.250e-15 1.288e-14 7.180e-01 0.47269
## Away_TeamCELTA 1.482e-14 1.109e-14 1.336e+00 0.18158
## Away_TeamCÓRDOBA 3.929e-15 1.886e-14 2.080e-01 0.83506
## Away_TeamDEPORTIVO 8.113e-15 1.202e-14 6.750e-01 0.49973
## Away_TeamEIBAR 3.268e-15 1.102e-14 2.970e-01 0.76687
## Away_TeamELCHE 1.217e-14 1.886e-14 6.450e-01 0.51880
## Away_TeamESPANYOL 2.738e-15 1.079e-14 2.540e-01 0.79967
## Away_TeamGETAFE 2.524e-15 1.134e-14 2.230e-01 0.82393
## Away_TeamGIJÓN 8.525e-16 1.454e-14 5.900e-02 0.95326
## Away_TeamGIRONA 4.338e-15 1.441e-14 3.010e-01 0.76338
## Away_TeamGRANADA 2.116e-15 1.184e-14 1.790e-01 0.85820
## Away_TeamHUESCA -7.336e-15 1.845e-14 -3.980e-01 0.69096
## Away_TeamLAS PALMAS 7.845e-15 1.330e-14 5.900e-01 0.55530
## Away_TeamLEGANÉS -1.421e-15 1.173e-14 -1.210e-01 0.90359
## Away_TeamLEVANTE 2.940e-15 1.119e-14 2.630e-01 0.79276
## Away_TeamMÁLAGA 3.987e-15 1.197e-14 3.330e-01 0.73909
## Away_TeamMALLORCA -1.262e-15 1.859e-14 -6.800e-02 0.94587
## Away_TeamOSASUNA -4.229e-16 1.438e-14 -2.900e-02 0.97654
## Away_TeamRAYO VALLECANO 9.250e-15 1.317e-14 7.030e-01 0.48236
## Away_TeamREAL BETIS 1.141e-14 1.163e-14 9.810e-01 0.32673
## Away_TeamREAL MADRID 2.422e-16 1.201e-14 2.000e-02 0.98391
## Away_TeamREAL SOCIEDAD 2.158e-15 1.108e-14 1.950e-01 0.84559
## Away_TeamSEVILLA FC 4.373e-15 1.109e-14 3.940e-01 0.69329
## Away_TeamVALENCIA 3.403e-15 1.102e-14 3.090e-01 0.75740
## Away_TeamVALLADOLID 4.521e-15 1.442e-14 3.140e-01 0.75391
## Away_TeamVILLARREAL 2.991e-15 1.101e-14 2.720e-01 0.78586
## `Home_Team_Possession_%` -6.413e-16 5.592e-16 -1.147e+00 0.25159
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots -1.440e-15 8.454e-15 -1.700e-01 0.86474
## Home_Team_On_Target_Shots -1.418e-15 8.455e-15 -1.680e-01 0.86683
## Home_Team_Total_Shots 2.014e-15 8.419e-15 2.390e-01 0.81092
## Home_Team_Blocked_Shots -2.676e-15 8.430e-15 -3.170e-01 0.75092
## Home_Team_Corners 1.000e+00 6.952e-16 1.439e+15 < 2e-16 ***
## Home_Team_Throw_Ins 4.072e-16 3.039e-16 1.340e+00 0.18040
## `Home_Team_Pass_Success_%` 1.103e-15 5.956e-16 1.853e+00 0.06405 .
## Home_Team_Aerials_Won 5.643e-17 3.163e-16 1.780e-01 0.85845
## Home_Team_Clearances 6.460e-16 2.695e-16 2.397e+00 0.01659 *
## Home_Team_Fouls 3.775e-16 4.428e-16 8.530e-01 0.39402
## Home_Team_Yellow_Cards -4.951e-16 1.136e-15 -4.360e-01 0.66312
## Home_Team_Second_Yellow_Cards -9.614e-17 6.484e-15 -1.500e-02 0.98817
## Home_Team_Red_Cards -6.173e-14 7.032e-15 -8.777e+00 < 2e-16 ***
## Away_Team_Off_Target_Shots 1.508e-15 7.260e-15 2.080e-01 0.83547
## Away_Team_On_Target_Shots 7.650e-16 7.291e-15 1.050e-01 0.91644
## Away_Team_Total_Shots -8.852e-16 7.236e-15 -1.220e-01 0.90264
## Away_Team_Blocked_Shots 1.946e-15 7.293e-15 2.670e-01 0.78963
## Away_Team_Corners 1.000e+00 7.607e-16 1.315e+15 < 2e-16 ***
## Away_Team_Throw_Ins 2.144e-16 3.248e-16 6.600e-01 0.50925
## `Away_Team_Pass_Success_%` -6.097e-16 5.548e-16 -1.099e+00 0.27188
## Away_Team_Aerials_Won -8.847e-17 3.125e-16 -2.830e-01 0.77715
## Away_Team_Clearances 1.831e-16 2.480e-16 7.380e-01 0.46055
## Away_Team_Fouls 6.692e-16 4.378e-16 1.528e+00 0.12655
## Away_Team_Yellow_Cards -3.324e-16 1.155e-15 -2.880e-01 0.77359
## Away_Team_Second_Yellow_Cards 5.051e-16 5.595e-15 9.000e-02 0.92807
## Away_Team_Red_Cards 6.042e-15 6.889e-15 8.770e-01 0.38057
## Home_Team_Goals_Scored 1.400e-15 1.989e-15 7.040e-01 0.48168
## Away_Team_Goals_Scored 1.466e-15 2.248e-15 6.520e-01 0.51418
## year -4.720e-13 2.046e-13 -2.307e+00 0.02113 *
## resultado2 1.084e-14 7.089e-15 1.529e+00 0.12639
## resultadox 7.419e-15 4.994e-15 1.486e+00 0.13754
## goles NA NA NA NA
## total_disparos NA NA NA NA
## total_disparos_bloqueados NA NA NA NA
## total_centros NA NA NA NA
## total_d_aereos NA NA NA NA
## total_despejes NA NA NA NA
## total_faltas NA NA NA NA
## total_amarillas NA NA NA NA
## total_rojas NA NA NA NA
## Home_points NA NA NA NA
## Away_points NA NA NA NA
## jornada -1.220e-14 5.384e-15 -2.267e+00 0.02351 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 7.136e-14 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 5.553e+28 on 92 and 2187 DF, p-value: < 2.2e-16
lm_centros <- lm(total_centros~., data = train)
summary(lm_centros)
##
## Call:
## lm(formula = total_centros ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4.561e-12 -1.320e-14 -2.500e-15 8.600e-15 6.560e-13
##
## Coefficients: (12 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.279e-09 5.956e-10 2.148e+00 0.031834 *
## ...1 1.683e-15 7.781e-16 2.163e+00 0.030613 *
## Home_TeamALMERÍA 8.982e-15 2.727e-14 3.290e-01 0.741949
## Home_TeamATHLETIC 9.438e-15 1.577e-14 5.990e-01 0.549515
## Home_TeamATLETICO MADRID 2.146e-15 1.595e-14 1.350e-01 0.893004
## Home_TeamBARCELONA 3.341e-14 1.854e-14 1.802e+00 0.071659 .
## Home_TeamCELTA 1.445e-14 1.624e-14 8.900e-01 0.373674
## Home_TeamCÓRDOBA 2.248e-14 2.729e-14 8.240e-01 0.410206
## Home_TeamDEPORTIVO 2.687e-15 1.732e-14 1.550e-01 0.876724
## Home_TeamEIBAR 5.974e-15 1.608e-14 3.720e-01 0.710198
## Home_TeamELCHE 1.171e-14 2.736e-14 4.280e-01 0.668734
## Home_TeamESPANYOL -1.293e-15 1.561e-14 -8.300e-02 0.933969
## Home_TeamGETAFE -5.727e-15 1.643e-14 -3.490e-01 0.727463
## Home_TeamGIJÓN 1.327e-14 2.121e-14 6.260e-01 0.531656
## Home_TeamGIRONA -2.835e-15 2.086e-14 -1.360e-01 0.891882
## Home_TeamGRANADA -1.696e-14 1.712e-14 -9.910e-01 0.321934
## Home_TeamHUESCA -2.742e-15 2.681e-14 -1.020e-01 0.918554
## Home_TeamLAS PALMAS 3.309e-15 1.954e-14 1.690e-01 0.865528
## Home_TeamLEGANÉS 1.003e-14 1.696e-14 5.910e-01 0.554605
## Home_TeamLEVANTE 9.695e-15 1.628e-14 5.950e-01 0.551632
## Home_TeamMÁLAGA -5.999e-14 1.728e-14 -3.471e+00 0.000529 ***
## Home_TeamMALLORCA -9.780e-15 2.691e-14 -3.630e-01 0.716291
## Home_TeamOSASUNA -2.108e-14 2.097e-14 -1.005e+00 0.315058
## Home_TeamRAYO VALLECANO 1.802e-14 1.901e-14 9.480e-01 0.343302
## Home_TeamREAL BETIS 3.281e-15 1.683e-14 1.950e-01 0.845468
## Home_TeamREAL MADRID 1.358e-14 1.762e-14 7.710e-01 0.440945
## Home_TeamREAL SOCIEDAD 2.423e-15 1.608e-14 1.510e-01 0.880186
## Home_TeamSEVILLA FC -2.065e-15 1.632e-14 -1.270e-01 0.899333
## Home_TeamVALENCIA 4.557e-15 1.602e-14 2.850e-01 0.776040
## Home_TeamVALLADOLID -1.345e-15 2.099e-14 -6.400e-02 0.948904
## Home_TeamVILLARREAL 4.258e-16 1.603e-14 2.700e-02 0.978814
## Away_TeamALMERÍA 1.862e-14 2.726e-14 6.830e-01 0.494639
## Away_TeamATHLETIC -3.856e-14 1.578e-14 -2.443e+00 0.014631 *
## Away_TeamATLETICO MADRID 5.965e-15 1.596e-14 3.740e-01 0.708710
## Away_TeamBARCELONA 1.505e-14 1.862e-14 8.080e-01 0.418978
## Away_TeamCELTA 3.889e-15 1.604e-14 2.420e-01 0.808426
## Away_TeamCÓRDOBA 5.232e-16 2.727e-14 1.900e-02 0.984694
## Away_TeamDEPORTIVO -7.569e-16 1.737e-14 -4.400e-02 0.965254
## Away_TeamEIBAR 1.049e-14 1.593e-14 6.580e-01 0.510297
## Away_TeamELCHE 5.249e-15 2.726e-14 1.930e-01 0.847349
## Away_TeamESPANYOL -6.853e-15 1.560e-14 -4.390e-01 0.660373
## Away_TeamGETAFE -1.629e-15 1.640e-14 -9.900e-02 0.920886
## Away_TeamGIJÓN -1.627e-14 2.102e-14 -7.740e-01 0.438976
## Away_TeamGIRONA 2.354e-15 2.083e-14 1.130e-01 0.910012
## Away_TeamGRANADA 1.501e-14 1.711e-14 8.770e-01 0.380618
## Away_TeamHUESCA -1.746e-14 2.667e-14 -6.550e-01 0.512827
## Away_TeamLAS PALMAS 5.988e-15 1.922e-14 3.120e-01 0.755447
## Away_TeamLEGANÉS -4.083e-15 1.696e-14 -2.410e-01 0.809794
## Away_TeamLEVANTE -3.903e-15 1.618e-14 -2.410e-01 0.809368
## Away_TeamMÁLAGA -8.357e-15 1.730e-14 -4.830e-01 0.629207
## Away_TeamMALLORCA -1.423e-14 2.688e-14 -5.290e-01 0.596595
## Away_TeamOSASUNA -7.924e-15 2.079e-14 -3.810e-01 0.703136
## Away_TeamRAYO VALLECANO 1.511e-15 1.903e-14 7.900e-02 0.936720
## Away_TeamREAL BETIS 3.906e-15 1.681e-14 2.320e-01 0.816304
## Away_TeamREAL MADRID -1.719e-15 1.736e-14 -9.900e-02 0.921138
## Away_TeamREAL SOCIEDAD -1.146e-14 1.602e-14 -7.150e-01 0.474391
## Away_TeamSEVILLA FC -8.318e-15 1.602e-14 -5.190e-01 0.603735
## Away_TeamVALENCIA -1.018e-15 1.592e-14 -6.400e-02 0.949042
## Away_TeamVALLADOLID -5.975e-15 2.085e-14 -2.870e-01 0.774433
## Away_TeamVILLARREAL -9.953e-15 1.591e-14 -6.260e-01 0.531667
## `Home_Team_Possession_%` -1.568e-15 8.083e-16 -1.940e+00 0.052567 .
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots 5.660e-16 1.222e-14 4.600e-02 0.963061
## Home_Team_On_Target_Shots 2.278e-15 1.222e-14 1.860e-01 0.852185
## Home_Team_Total_Shots 7.931e-17 1.217e-14 7.000e-03 0.994801
## Home_Team_Blocked_Shots -1.246e-15 1.219e-14 -1.020e-01 0.918603
## Home_Team_Corners -4.752e-16 1.005e-15 -4.730e-01 0.636339
## Home_Team_Throw_Ins 1.000e+00 4.392e-16 2.277e+15 < 2e-16 ***
## `Home_Team_Pass_Success_%` 2.516e-15 8.609e-16 2.923e+00 0.003506 **
## Home_Team_Aerials_Won 4.588e-17 4.573e-16 1.000e-01 0.920087
## Home_Team_Clearances -1.845e-16 3.895e-16 -4.740e-01 0.635808
## Home_Team_Fouls 1.052e-15 6.400e-16 1.643e+00 0.100524
## Home_Team_Yellow_Cards -2.302e-16 1.643e-15 -1.400e-01 0.888567
## Home_Team_Second_Yellow_Cards 1.835e-15 9.372e-15 1.960e-01 0.844780
## Home_Team_Red_Cards -8.440e-14 1.017e-14 -8.303e+00 < 2e-16 ***
## Away_Team_Off_Target_Shots 2.376e-15 1.049e-14 2.260e-01 0.820881
## Away_Team_On_Target_Shots -4.387e-16 1.054e-14 -4.200e-02 0.966799
## Away_Team_Total_Shots -6.522e-16 1.046e-14 -6.200e-02 0.950288
## Away_Team_Blocked_Shots 1.204e-15 1.054e-14 1.140e-01 0.909067
## Away_Team_Corners 1.681e-15 1.100e-15 1.529e+00 0.126525
## Away_Team_Throw_Ins 1.000e+00 4.696e-16 2.130e+15 < 2e-16 ***
## `Away_Team_Pass_Success_%` -6.680e-16 8.020e-16 -8.330e-01 0.405003
## Away_Team_Aerials_Won -1.403e-16 4.518e-16 -3.110e-01 0.756199
## Away_Team_Clearances 3.342e-16 3.585e-16 9.320e-01 0.351382
## Away_Team_Fouls 9.319e-16 6.329e-16 1.472e+00 0.141063
## Away_Team_Yellow_Cards -6.374e-16 1.670e-15 -3.820e-01 0.702764
## Away_Team_Second_Yellow_Cards 3.181e-15 8.087e-15 3.930e-01 0.694108
## Away_Team_Red_Cards 1.157e-14 9.958e-15 1.161e+00 0.245595
## Home_Team_Goals_Scored 2.836e-15 2.875e-15 9.860e-01 0.324029
## Away_Team_Goals_Scored 1.630e-15 3.249e-15 5.020e-01 0.615961
## year -6.354e-13 2.957e-13 -2.148e+00 0.031785 *
## resultado2 1.861e-14 1.025e-14 1.816e+00 0.069551 .
## resultadox 1.171e-14 7.219e-15 1.622e+00 0.104898
## goles NA NA NA NA
## total_disparos NA NA NA NA
## total_disparos_bloqueados NA NA NA NA
## total_corners NA NA NA NA
## total_d_aereos NA NA NA NA
## total_despejes NA NA NA NA
## total_faltas NA NA NA NA
## total_amarillas NA NA NA NA
## total_rojas NA NA NA NA
## Home_points NA NA NA NA
## Away_points NA NA NA NA
## jornada -1.638e-14 7.783e-15 -2.104e+00 0.035454 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.032e-13 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 2.616e+29 on 92 and 2187 DF, p-value: < 2.2e-16
lm_d_aereos <- lm(total_d_aereos~., data = train)
summary(lm_d_aereos)
##
## Call:
## lm(formula = total_d_aereos ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.409e-12 -6.110e-15 -6.600e-16 5.370e-15 6.267e-13
##
## Coefficients: (12 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.964e-10 2.266e-10 8.670e-01 0.386164
## ...1 2.661e-16 2.961e-16 8.990e-01 0.368910
## Home_TeamALMERÍA 4.345e-15 1.038e-14 4.190e-01 0.675488
## Home_TeamATHLETIC 2.631e-14 6.000e-15 4.386e+00 1.21e-05 ***
## Home_TeamATLETICO MADRID 1.676e-14 6.071e-15 2.761e+00 0.005812 **
## Home_TeamBARCELONA -2.925e-14 7.055e-15 -4.146e+00 3.51e-05 ***
## Home_TeamCELTA 1.686e-14 6.180e-15 2.727e+00 0.006435 **
## Home_TeamCÓRDOBA 2.973e-14 1.039e-14 2.862e+00 0.004251 **
## Home_TeamDEPORTIVO 1.695e-14 6.591e-15 2.571e+00 0.010196 *
## Home_TeamEIBAR -9.792e-15 6.117e-15 -1.601e+00 0.109595
## Home_TeamELCHE 1.849e-14 1.041e-14 1.776e+00 0.075824 .
## Home_TeamESPANYOL 2.433e-14 5.939e-15 4.096e+00 4.36e-05 ***
## Home_TeamGETAFE 2.789e-15 6.253e-15 4.460e-01 0.655656
## Home_TeamGIJÓN 2.944e-15 8.071e-15 3.650e-01 0.715323
## Home_TeamGIRONA 4.519e-15 7.936e-15 5.690e-01 0.569145
## Home_TeamGRANADA 8.437e-15 6.515e-15 1.295e+00 0.195435
## Home_TeamHUESCA 1.931e-14 1.020e-14 1.893e+00 0.058449 .
## Home_TeamLAS PALMAS 2.714e-14 7.434e-15 3.650e+00 0.000268 ***
## Home_TeamLEGANÉS 1.616e-14 6.456e-15 2.503e+00 0.012378 *
## Home_TeamLEVANTE 7.478e-15 6.196e-15 1.207e+00 0.227626
## Home_TeamMÁLAGA -3.570e-15 6.577e-15 -5.430e-01 0.587304
## Home_TeamMALLORCA 2.996e-14 1.024e-14 2.926e+00 0.003470 **
## Home_TeamOSASUNA -2.142e-14 7.981e-15 -2.684e+00 0.007322 **
## Home_TeamRAYO VALLECANO 1.318e-14 7.234e-15 1.822e+00 0.068565 .
## Home_TeamREAL BETIS 7.066e-15 6.406e-15 1.103e+00 0.270145
## Home_TeamREAL MADRID 2.102e-14 6.706e-15 3.135e+00 0.001744 **
## Home_TeamREAL SOCIEDAD 1.722e-14 6.117e-15 2.814e+00 0.004933 **
## Home_TeamSEVILLA FC 1.184e-14 6.210e-15 1.906e+00 0.056764 .
## Home_TeamVALENCIA 1.186e-14 6.094e-15 1.947e+00 0.051715 .
## Home_TeamVALLADOLID 1.209e-14 7.987e-15 1.514e+00 0.130292
## Home_TeamVILLARREAL 2.666e-14 6.101e-15 4.370e+00 1.30e-05 ***
## Away_TeamALMERÍA 8.576e-15 1.037e-14 8.270e-01 0.408383
## Away_TeamATHLETIC 2.122e-15 6.005e-15 3.530e-01 0.723882
## Away_TeamATLETICO MADRID 2.196e-14 6.075e-15 3.615e+00 0.000308 ***
## Away_TeamBARCELONA -6.251e-14 7.084e-15 -8.824e+00 < 2e-16 ***
## Away_TeamCELTA 9.182e-15 6.102e-15 1.505e+00 0.132539
## Away_TeamCÓRDOBA 1.043e-14 1.038e-14 1.005e+00 0.315128
## Away_TeamDEPORTIVO 1.003e-14 6.611e-15 1.517e+00 0.129299
## Away_TeamEIBAR 2.040e-14 6.063e-15 3.364e+00 0.000781 ***
## Away_TeamELCHE 1.337e-14 1.037e-14 1.289e+00 0.197686
## Away_TeamESPANYOL 2.366e-16 5.934e-15 4.000e-02 0.968205
## Away_TeamGETAFE -1.128e-14 6.240e-15 -1.808e+00 0.070712 .
## Away_TeamGIJÓN -3.893e-15 8.000e-15 -4.870e-01 0.626537
## Away_TeamGIRONA 1.645e-14 7.926e-15 2.075e+00 0.038097 *
## Away_TeamGRANADA 3.232e-15 6.513e-15 4.960e-01 0.619789
## Away_TeamHUESCA -8.399e-15 1.015e-14 -8.280e-01 0.408002
## Away_TeamLAS PALMAS 2.448e-14 7.315e-15 3.346e+00 0.000834 ***
## Away_TeamLEGANÉS -5.181e-17 6.454e-15 -8.000e-03 0.993596
## Away_TeamLEVANTE 3.237e-15 6.156e-15 5.260e-01 0.599098
## Away_TeamMÁLAGA 5.105e-15 6.585e-15 7.750e-01 0.438267
## Away_TeamMALLORCA 1.801e-14 1.023e-14 1.761e+00 0.078394 .
## Away_TeamOSASUNA -1.724e-15 7.911e-15 -2.180e-01 0.827489
## Away_TeamRAYO VALLECANO -1.662e-14 7.242e-15 -2.295e+00 0.021811 *
## Away_TeamREAL BETIS 4.912e-15 6.397e-15 7.680e-01 0.442688
## Away_TeamREAL MADRID 1.544e-14 6.605e-15 2.338e+00 0.019483 *
## Away_TeamREAL SOCIEDAD 3.695e-15 6.096e-15 6.060e-01 0.544483
## Away_TeamSEVILLA FC 8.350e-15 6.098e-15 1.369e+00 0.171048
## Away_TeamVALENCIA 5.095e-15 6.060e-15 8.410e-01 0.400528
## Away_TeamVALLADOLID 7.520e-15 7.933e-15 9.480e-01 0.343224
## Away_TeamVILLARREAL 3.972e-15 6.055e-15 6.560e-01 0.511879
## `Home_Team_Possession_%` 4.632e-16 3.076e-16 1.506e+00 0.132261
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots 1.935e-15 4.650e-15 4.160e-01 0.677327
## Home_Team_On_Target_Shots 3.656e-16 4.651e-15 7.900e-02 0.937355
## Home_Team_Total_Shots -1.289e-15 4.631e-15 -2.780e-01 0.780741
## Home_Team_Blocked_Shots 1.097e-15 4.637e-15 2.370e-01 0.813007
## Home_Team_Corners 1.692e-16 3.824e-16 4.420e-01 0.658200
## Home_Team_Throw_Ins -2.690e-16 1.671e-16 -1.610e+00 0.107647
## `Home_Team_Pass_Success_%` -1.888e-15 3.276e-16 -5.761e+00 9.52e-09 ***
## Home_Team_Aerials_Won 1.000e+00 1.740e-16 5.747e+15 < 2e-16 ***
## Home_Team_Clearances 2.143e-16 1.482e-16 1.446e+00 0.148368
## Home_Team_Fouls 3.788e-16 2.436e-16 1.555e+00 0.120037
## Home_Team_Yellow_Cards -3.871e-17 6.251e-16 -6.200e-02 0.950620
## Home_Team_Second_Yellow_Cards 3.306e-15 3.566e-15 9.270e-01 0.354000
## Home_Team_Red_Cards -2.979e-14 3.868e-15 -7.701e+00 2.04e-14 ***
## Away_Team_Off_Target_Shots -1.096e-15 3.994e-15 -2.740e-01 0.783827
## Away_Team_On_Target_Shots -1.942e-15 4.010e-15 -4.840e-01 0.628343
## Away_Team_Total_Shots 1.630e-15 3.980e-15 4.090e-01 0.682291
## Away_Team_Blocked_Shots -1.912e-15 4.012e-15 -4.760e-01 0.633784
## Away_Team_Corners -2.189e-16 4.185e-16 -5.230e-01 0.600876
## Away_Team_Throw_Ins -1.553e-16 1.787e-16 -8.690e-01 0.384972
## `Away_Team_Pass_Success_%` -1.052e-15 3.052e-16 -3.446e+00 0.000580 ***
## Away_Team_Aerials_Won 1.000e+00 1.719e-16 5.817e+15 < 2e-16 ***
## Away_Team_Clearances 7.167e-18 1.364e-16 5.300e-02 0.958110
## Away_Team_Fouls 3.612e-16 2.408e-16 1.500e+00 0.133843
## Away_Team_Yellow_Cards 3.082e-16 6.356e-16 4.850e-01 0.627847
## Away_Team_Second_Yellow_Cards -2.030e-15 3.077e-15 -6.600e-01 0.509526
## Away_Team_Red_Cards 1.201e-15 3.789e-15 3.170e-01 0.751246
## Home_Team_Goals_Scored 1.478e-15 1.094e-15 1.350e+00 0.177010
## Away_Team_Goals_Scored 3.674e-16 1.236e-15 2.970e-01 0.766345
## year -9.746e-14 1.125e-13 -8.660e-01 0.386574
## resultado2 8.638e-15 3.899e-15 2.215e+00 0.026848 *
## resultadox 5.450e-15 2.747e-15 1.984e+00 0.047417 *
## goles NA NA NA NA
## total_disparos NA NA NA NA
## total_disparos_bloqueados NA NA NA NA
## total_corners NA NA NA NA
## total_centros NA NA NA NA
## total_despejes NA NA NA NA
## total_faltas NA NA NA NA
## total_amarillas NA NA NA NA
## total_rojas NA NA NA NA
## Home_points NA NA NA NA
## Away_points NA NA NA NA
## jornada -2.441e-15 2.962e-15 -8.240e-01 0.409861
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 3.925e-14 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 2.847e+30 on 92 and 2187 DF, p-value: < 2.2e-16
lm_despejes <- lm(total_despejes~., data = train)
summary(lm_despejes)
## Warning in summary.lm(lm_despejes): essentially perfect fit: summary may be
## unreliable
##
## Call:
## lm(formula = total_despejes ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -1.384e-12 -6.370e-15 -4.700e-16 6.720e-15 3.155e-13
##
## Coefficients: (12 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 2.451e-10 2.380e-10 1.030e+00 0.303274
## ...1 3.139e-16 3.109e-16 1.009e+00 0.312853
## Home_TeamALMERÍA 3.201e-14 1.090e-14 2.937e+00 0.003349 **
## Home_TeamATHLETIC 4.102e-14 6.300e-15 6.510e+00 9.29e-11 ***
## Home_TeamATLETICO MADRID 2.567e-14 6.376e-15 4.027e+00 5.85e-05 ***
## Home_TeamBARCELONA 1.654e-14 7.408e-15 2.233e+00 0.025672 *
## Home_TeamCELTA 2.956e-14 6.490e-15 4.556e+00 5.51e-06 ***
## Home_TeamCÓRDOBA 2.082e-14 1.091e-14 1.909e+00 0.056414 .
## Home_TeamDEPORTIVO 2.790e-14 6.921e-15 4.031e+00 5.73e-05 ***
## Home_TeamEIBAR 3.734e-14 6.424e-15 5.812e+00 7.07e-09 ***
## Home_TeamELCHE 1.135e-14 1.093e-14 1.038e+00 0.299429
## Home_TeamESPANYOL 1.398e-14 6.237e-15 2.242e+00 0.025047 *
## Home_TeamGETAFE 6.179e-15 6.566e-15 9.410e-01 0.346799
## Home_TeamGIJÓN 2.463e-14 8.475e-15 2.906e+00 0.003701 **
## Home_TeamGIRONA 2.812e-14 8.334e-15 3.374e+00 0.000754 ***
## Home_TeamGRANADA 1.265e-14 6.841e-15 1.849e+00 0.064597 .
## Home_TeamHUESCA 3.474e-14 1.071e-14 3.242e+00 0.001203 **
## Home_TeamLAS PALMAS 3.224e-14 7.807e-15 4.130e+00 3.76e-05 ***
## Home_TeamLEGANÉS 2.053e-14 6.779e-15 3.028e+00 0.002493 **
## Home_TeamLEVANTE 2.802e-14 6.507e-15 4.306e+00 1.74e-05 ***
## Home_TeamMÁLAGA 8.625e-15 6.907e-15 1.249e+00 0.211885
## Home_TeamMALLORCA 1.020e-14 1.075e-14 9.490e-01 0.342750
## Home_TeamOSASUNA 2.575e-14 8.381e-15 3.072e+00 0.002153 **
## Home_TeamRAYO VALLECANO 2.180e-14 7.597e-15 2.869e+00 0.004153 **
## Home_TeamREAL BETIS 2.531e-14 6.727e-15 3.763e+00 0.000173 ***
## Home_TeamREAL MADRID 3.311e-14 7.042e-15 4.703e+00 2.73e-06 ***
## Home_TeamREAL SOCIEDAD 3.010e-14 6.424e-15 4.685e+00 2.97e-06 ***
## Home_TeamSEVILLA FC 4.758e-14 6.522e-15 7.295e+00 4.15e-13 ***
## Home_TeamVALENCIA 1.910e-14 6.400e-15 2.985e+00 0.002870 **
## Home_TeamVALLADOLID 1.335e-14 8.387e-15 1.592e+00 0.111610
## Home_TeamVILLARREAL 1.935e-14 6.406e-15 3.020e+00 0.002557 **
## Away_TeamALMERÍA -2.942e-14 1.089e-14 -2.701e+00 0.006958 **
## Away_TeamATHLETIC -4.387e-14 6.306e-15 -6.956e+00 4.60e-12 ***
## Away_TeamATLETICO MADRID -4.127e-14 6.379e-15 -6.469e+00 1.21e-10 ***
## Away_TeamBARCELONA -3.339e-14 7.439e-15 -4.489e+00 7.53e-06 ***
## Away_TeamCELTA -2.867e-14 6.408e-15 -4.474e+00 8.08e-06 ***
## Away_TeamCÓRDOBA 4.079e-15 1.090e-14 3.740e-01 0.708180
## Away_TeamDEPORTIVO -2.138e-14 6.942e-15 -3.080e+00 0.002094 **
## Away_TeamEIBAR -3.296e-14 6.367e-15 -5.177e+00 2.47e-07 ***
## Away_TeamELCHE -2.126e-14 1.089e-14 -1.951e+00 0.051152 .
## Away_TeamESPANYOL -1.810e-14 6.232e-15 -2.905e+00 0.003709 **
## Away_TeamGETAFE -1.719e-14 6.553e-15 -2.623e+00 0.008787 **
## Away_TeamGIJÓN -7.920e-15 8.400e-15 -9.430e-01 0.345900
## Away_TeamGIRONA -1.502e-14 8.323e-15 -1.805e+00 0.071234 .
## Away_TeamGRANADA -1.483e-14 6.839e-15 -2.168e+00 0.030290 *
## Away_TeamHUESCA -3.403e-15 1.066e-14 -3.190e-01 0.749555
## Away_TeamLAS PALMAS -4.276e-14 7.682e-15 -5.567e+00 2.91e-08 ***
## Away_TeamLEGANÉS -2.122e-14 6.778e-15 -3.131e+00 0.001764 **
## Away_TeamLEVANTE -1.499e-14 6.464e-15 -2.319e+00 0.020486 *
## Away_TeamMÁLAGA -2.776e-14 6.915e-15 -4.015e+00 6.16e-05 ***
## Away_TeamMALLORCA -2.882e-14 1.074e-14 -2.683e+00 0.007354 **
## Away_TeamOSASUNA -6.623e-15 8.308e-15 -7.970e-01 0.425434
## Away_TeamRAYO VALLECANO -2.297e-14 7.605e-15 -3.021e+00 0.002550 **
## Away_TeamREAL BETIS -2.025e-14 6.718e-15 -3.014e+00 0.002608 **
## Away_TeamREAL MADRID -6.095e-14 6.936e-15 -8.787e+00 < 2e-16 ***
## Away_TeamREAL SOCIEDAD -2.286e-14 6.401e-15 -3.571e+00 0.000363 ***
## Away_TeamSEVILLA FC -2.705e-14 6.403e-15 -4.225e+00 2.49e-05 ***
## Away_TeamVALENCIA -8.078e-15 6.364e-15 -1.269e+00 0.204402
## Away_TeamVALLADOLID -3.326e-15 8.330e-15 -3.990e-01 0.689731
## Away_TeamVILLARREAL -9.608e-15 6.358e-15 -1.511e+00 0.130904
## `Home_Team_Possession_%` -9.239e-16 3.230e-16 -2.860e+00 0.004271 **
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots 4.263e-16 4.883e-15 8.700e-02 0.930446
## Home_Team_On_Target_Shots 1.082e-15 4.884e-15 2.220e-01 0.824636
## Home_Team_Total_Shots -3.808e-17 4.863e-15 -8.000e-03 0.993752
## Home_Team_Blocked_Shots 8.539e-16 4.870e-15 1.750e-01 0.860819
## Home_Team_Corners -9.671e-16 4.016e-16 -2.408e+00 0.016108 *
## Home_Team_Throw_Ins 1.130e-15 1.755e-16 6.439e+00 1.48e-10 ***
## `Home_Team_Pass_Success_%` -3.685e-17 3.440e-16 -1.070e-01 0.914715
## Home_Team_Aerials_Won 5.874e-17 1.827e-16 3.210e-01 0.747889
## Home_Team_Clearances 1.000e+00 1.556e-16 6.425e+15 < 2e-16 ***
## Home_Team_Fouls 2.125e-16 2.558e-16 8.310e-01 0.406140
## Home_Team_Yellow_Cards 7.219e-16 6.564e-16 1.100e+00 0.271556
## Home_Team_Second_Yellow_Cards 1.355e-15 3.745e-15 3.620e-01 0.717628
## Home_Team_Red_Cards -2.667e-14 4.062e-15 -6.565e+00 6.48e-11 ***
## Away_Team_Off_Target_Shots 4.238e-15 4.194e-15 1.011e+00 0.312341
## Away_Team_On_Target_Shots 3.139e-15 4.211e-15 7.450e-01 0.456087
## Away_Team_Total_Shots -3.236e-15 4.180e-15 -7.740e-01 0.438864
## Away_Team_Blocked_Shots 3.412e-15 4.213e-15 8.100e-01 0.418137
## Away_Team_Corners -4.319e-16 4.394e-16 -9.830e-01 0.325806
## Away_Team_Throw_Ins 2.197e-17 1.876e-16 1.170e-01 0.906789
## `Away_Team_Pass_Success_%` 2.711e-16 3.205e-16 8.460e-01 0.397639
## Away_Team_Aerials_Won 1.230e-16 1.805e-16 6.820e-01 0.495582
## Away_Team_Clearances 1.000e+00 1.433e-16 6.980e+15 < 2e-16 ***
## Away_Team_Fouls 1.961e-16 2.529e-16 7.750e-01 0.438175
## Away_Team_Yellow_Cards 1.458e-16 6.674e-16 2.180e-01 0.827112
## Away_Team_Second_Yellow_Cards 3.318e-16 3.232e-15 1.030e-01 0.918225
## Away_Team_Red_Cards 8.245e-15 3.979e-15 2.072e+00 0.038387 *
## Home_Team_Goals_Scored -6.771e-17 1.149e-15 -5.900e-02 0.953017
## Away_Team_Goals_Scored 1.123e-15 1.298e-15 8.650e-01 0.387204
## year -1.217e-13 1.182e-13 -1.030e+00 0.303166
## resultado2 2.855e-15 4.095e-15 6.970e-01 0.485762
## resultadox 2.584e-16 2.885e-15 9.000e-02 0.928632
## goles NA NA NA NA
## total_disparos NA NA NA NA
## total_disparos_bloqueados NA NA NA NA
## total_corners NA NA NA NA
## total_centros NA NA NA NA
## total_d_aereos NA NA NA NA
## total_faltas NA NA NA NA
## total_amarillas NA NA NA NA
## total_rojas NA NA NA NA
## Home_points NA NA NA NA
## Away_points NA NA NA NA
## jornada -2.994e-15 3.110e-15 -9.630e-01 0.335786
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 4.122e-14 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 1.858e+30 on 92 and 2187 DF, p-value: < 2.2e-16
lm_faltas <- lm(total_faltas~., data = train)
summary(lm_faltas)
##
## Call:
## lm(formula = total_faltas ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -6.540e-13 -1.200e-14 6.000e-15 2.250e-14 7.834e-12
##
## Coefficients: (12 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -2.030e-09 1.006e-09 -2.018e+00 0.04374 *
## ...1 -2.666e-15 1.315e-15 -2.028e+00 0.04268 *
## Home_TeamALMERÍA -3.147e-14 4.608e-14 -6.830e-01 0.49466
## Home_TeamATHLETIC -1.332e-14 2.664e-14 -5.000e-01 0.61719
## Home_TeamATLETICO MADRID -1.377e-14 2.695e-14 -5.110e-01 0.60952
## Home_TeamBARCELONA -3.961e-14 3.132e-14 -1.265e+00 0.20614
## Home_TeamCELTA -2.154e-14 2.744e-14 -7.850e-01 0.43250
## Home_TeamCÓRDOBA -1.465e-14 4.611e-14 -3.180e-01 0.75071
## Home_TeamDEPORTIVO -1.459e-14 2.926e-14 -4.990e-01 0.61803
## Home_TeamEIBAR -1.863e-14 2.716e-14 -6.860e-01 0.49276
## Home_TeamELCHE -1.212e-14 4.622e-14 -2.620e-01 0.79320
## Home_TeamESPANYOL -4.794e-15 2.637e-14 -1.820e-01 0.85574
## Home_TeamGETAFE -2.246e-14 2.776e-14 -8.090e-01 0.41850
## Home_TeamGIJÓN -2.376e-14 3.583e-14 -6.630e-01 0.50736
## Home_TeamGIRONA 5.732e-15 3.523e-14 1.630e-01 0.87079
## Home_TeamGRANADA -6.143e-15 2.892e-14 -2.120e-01 0.83181
## Home_TeamHUESCA 3.974e-15 4.529e-14 8.800e-02 0.93008
## Home_TeamLAS PALMAS -1.534e-14 3.301e-14 -4.650e-01 0.64207
## Home_TeamLEGANÉS -1.316e-14 2.866e-14 -4.590e-01 0.64628
## Home_TeamLEVANTE -2.566e-14 2.751e-14 -9.330e-01 0.35105
## Home_TeamMÁLAGA 8.515e-14 2.920e-14 2.916e+00 0.00358 **
## Home_TeamMALLORCA -1.205e-14 4.546e-14 -2.650e-01 0.79101
## Home_TeamOSASUNA -1.714e-14 3.543e-14 -4.840e-01 0.62855
## Home_TeamRAYO VALLECANO -2.052e-14 3.212e-14 -6.390e-01 0.52296
## Home_TeamREAL BETIS -1.883e-14 2.844e-14 -6.620e-01 0.50804
## Home_TeamREAL MADRID -2.790e-14 2.977e-14 -9.370e-01 0.34884
## Home_TeamREAL SOCIEDAD -1.570e-14 2.716e-14 -5.780e-01 0.56320
## Home_TeamSEVILLA FC -9.330e-15 2.757e-14 -3.380e-01 0.73509
## Home_TeamVALENCIA -1.069e-14 2.706e-14 -3.950e-01 0.69269
## Home_TeamVALLADOLID -9.416e-15 3.546e-14 -2.660e-01 0.79062
## Home_TeamVILLARREAL -1.324e-14 2.708e-14 -4.890e-01 0.62508
## Away_TeamALMERÍA 7.144e-15 4.605e-14 1.550e-01 0.87672
## Away_TeamATHLETIC 6.895e-14 2.666e-14 2.586e+00 0.00976 **
## Away_TeamATLETICO MADRID -8.674e-15 2.697e-14 -3.220e-01 0.74777
## Away_TeamBARCELONA -1.308e-14 3.145e-14 -4.160e-01 0.67745
## Away_TeamCELTA -4.419e-15 2.709e-14 -1.630e-01 0.87045
## Away_TeamCÓRDOBA -1.860e-14 4.607e-14 -4.040e-01 0.68653
## Away_TeamDEPORTIVO -8.812e-16 2.935e-14 -3.000e-02 0.97605
## Away_TeamEIBAR -1.320e-14 2.692e-14 -4.900e-01 0.62386
## Away_TeamELCHE -2.374e-14 4.606e-14 -5.150e-01 0.60632
## Away_TeamESPANYOL -3.244e-15 2.635e-14 -1.230e-01 0.90201
## Away_TeamGETAFE -8.175e-15 2.770e-14 -2.950e-01 0.76797
## Away_TeamGIJÓN 6.303e-15 3.552e-14 1.770e-01 0.85915
## Away_TeamGIRONA -5.516e-15 3.519e-14 -1.570e-01 0.87543
## Away_TeamGRANADA -1.026e-14 2.891e-14 -3.550e-01 0.72278
## Away_TeamHUESCA 1.033e-15 4.506e-14 2.300e-02 0.98172
## Away_TeamLAS PALMAS -4.880e-15 3.248e-14 -1.500e-01 0.88056
## Away_TeamLEGANÉS -5.360e-15 2.865e-14 -1.870e-01 0.85162
## Away_TeamLEVANTE -9.317e-15 2.733e-14 -3.410e-01 0.73320
## Away_TeamMÁLAGA -7.351e-16 2.924e-14 -2.500e-02 0.97994
## Away_TeamMALLORCA 9.031e-15 4.541e-14 1.990e-01 0.84236
## Away_TeamOSASUNA -2.775e-15 3.512e-14 -7.900e-02 0.93703
## Away_TeamRAYO VALLECANO -8.693e-15 3.215e-14 -2.700e-01 0.78691
## Away_TeamREAL BETIS -1.095e-14 2.840e-14 -3.860e-01 0.69977
## Away_TeamREAL MADRID 9.321e-15 2.932e-14 3.180e-01 0.75061
## Away_TeamREAL SOCIEDAD 1.415e-15 2.706e-14 5.200e-02 0.95831
## Away_TeamSEVILLA FC -3.217e-15 2.707e-14 -1.190e-01 0.90541
## Away_TeamVALENCIA 1.320e-14 2.690e-14 4.910e-01 0.62379
## Away_TeamVALLADOLID 7.821e-15 3.522e-14 2.220e-01 0.82429
## Away_TeamVILLARREAL -3.457e-15 2.688e-14 -1.290e-01 0.89767
## `Home_Team_Possession_%` 1.887e-15 1.366e-15 1.382e+00 0.16719
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots -1.500e-15 2.065e-14 -7.300e-02 0.94210
## Home_Team_On_Target_Shots -2.531e-15 2.065e-14 -1.230e-01 0.90246
## Home_Team_Total_Shots 8.683e-16 2.056e-14 4.200e-02 0.96632
## Home_Team_Blocked_Shots 1.490e-15 2.059e-14 7.200e-02 0.94229
## Home_Team_Corners -1.493e-16 1.698e-15 -8.800e-02 0.92994
## Home_Team_Throw_Ins -1.454e-15 7.421e-16 -1.960e+00 0.05014 .
## `Home_Team_Pass_Success_%` -3.372e-15 1.454e-15 -2.318e+00 0.02052 *
## Home_Team_Aerials_Won -9.033e-17 7.726e-16 -1.170e-01 0.90693
## Home_Team_Clearances -8.960e-16 6.581e-16 -1.362e+00 0.17347
## Home_Team_Fouls 1.000e+00 1.081e-15 9.248e+14 < 2e-16 ***
## Home_Team_Yellow_Cards 1.551e-15 2.775e-15 5.590e-01 0.57628
## Home_Team_Second_Yellow_Cards 1.594e-15 1.583e-14 1.010e-01 0.91980
## Home_Team_Red_Cards 1.545e-13 1.717e-14 8.996e+00 < 2e-16 ***
## Away_Team_Off_Target_Shots -4.290e-15 1.773e-14 -2.420e-01 0.80885
## Away_Team_On_Target_Shots -3.038e-16 1.780e-14 -1.700e-02 0.98639
## Away_Team_Total_Shots 3.031e-15 1.767e-14 1.720e-01 0.86384
## Away_Team_Blocked_Shots -4.008e-15 1.781e-14 -2.250e-01 0.82199
## Away_Team_Corners -6.562e-16 1.858e-15 -3.530e-01 0.72397
## Away_Team_Throw_Ins -4.620e-16 7.933e-16 -5.820e-01 0.56041
## `Away_Team_Pass_Success_%` 1.370e-15 1.355e-15 1.011e+00 0.31219
## Away_Team_Aerials_Won 1.273e-17 7.633e-16 1.700e-02 0.98669
## Away_Team_Clearances -4.490e-16 6.057e-16 -7.410e-01 0.45857
## Away_Team_Fouls 1.000e+00 1.069e-15 9.352e+14 < 2e-16 ***
## Away_Team_Yellow_Cards 2.631e-16 2.822e-15 9.300e-02 0.92572
## Away_Team_Second_Yellow_Cards -3.285e-15 1.366e-14 -2.400e-01 0.81002
## Away_Team_Red_Cards -1.634e-14 1.682e-14 -9.710e-01 0.33149
## Home_Team_Goals_Scored -4.073e-15 4.858e-15 -8.380e-01 0.40189
## Away_Team_Goals_Scored -3.635e-15 5.489e-15 -6.620e-01 0.50790
## year 1.008e-12 4.996e-13 2.018e+00 0.04369 *
## resultado2 -3.153e-14 1.731e-14 -1.821e+00 0.06869 .
## resultadox -2.001e-14 1.220e-14 -1.640e+00 0.10106
## goles NA NA NA NA
## total_disparos NA NA NA NA
## total_disparos_bloqueados NA NA NA NA
## total_corners NA NA NA NA
## total_centros NA NA NA NA
## total_d_aereos NA NA NA NA
## total_despejes NA NA NA NA
## total_amarillas NA NA NA NA
## total_rojas NA NA NA NA
## Home_points NA NA NA NA
## Away_points NA NA NA NA
## jornada 2.605e-14 1.315e-14 1.981e+00 0.04773 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 1.743e-13 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 2.84e+28 on 92 and 2187 DF, p-value: < 2.2e-16
lm_amarillas <- lm(total_amarillas~., data = train)
summary(lm_amarillas)
##
## Call:
## lm(formula = total_amarillas ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -3.378e-12 -9.500e-15 -2.300e-15 5.500e-15 1.379e-13
##
## Coefficients: (12 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 9.795e-10 4.328e-10 2.263e+00 0.02373 *
## ...1 1.286e-15 5.655e-16 2.275e+00 0.02301 *
## Home_TeamALMERÍA 1.301e-15 1.982e-14 6.600e-02 0.94767
## Home_TeamATHLETIC -7.515e-16 1.146e-14 -6.600e-02 0.94771
## Home_TeamATLETICO MADRID 3.251e-15 1.159e-14 2.800e-01 0.77919
## Home_TeamBARCELONA 6.030e-15 1.347e-14 4.480e-01 0.65448
## Home_TeamCELTA 3.854e-15 1.180e-14 3.270e-01 0.74405
## Home_TeamCÓRDOBA 7.879e-16 1.984e-14 4.000e-02 0.96832
## Home_TeamDEPORTIVO 2.029e-15 1.259e-14 1.610e-01 0.87194
## Home_TeamEIBAR -1.122e-15 1.168e-14 -9.600e-02 0.92348
## Home_TeamELCHE 7.758e-15 1.988e-14 3.900e-01 0.69638
## Home_TeamESPANYOL -5.897e-17 1.134e-14 -5.000e-03 0.99585
## Home_TeamGETAFE 3.458e-15 1.194e-14 2.900e-01 0.77214
## Home_TeamGIJÓN 9.729e-15 1.541e-14 6.310e-01 0.52800
## Home_TeamGIRONA -3.542e-15 1.516e-14 -2.340e-01 0.81523
## Home_TeamGRANADA 1.389e-15 1.244e-14 1.120e-01 0.91110
## Home_TeamHUESCA -7.080e-15 1.948e-14 -3.630e-01 0.71636
## Home_TeamLAS PALMAS 3.694e-16 1.420e-14 2.600e-02 0.97925
## Home_TeamLEGANÉS 2.749e-15 1.233e-14 2.230e-01 0.82357
## Home_TeamLEVANTE 4.085e-15 1.183e-14 3.450e-01 0.72999
## Home_TeamMÁLAGA -3.942e-14 1.256e-14 -3.138e+00 0.00172 **
## Home_TeamMALLORCA -7.127e-16 1.955e-14 -3.600e-02 0.97093
## Home_TeamOSASUNA -1.124e-15 1.524e-14 -7.400e-02 0.94123
## Home_TeamRAYO VALLECANO 3.938e-15 1.382e-14 2.850e-01 0.77563
## Home_TeamREAL BETIS 4.570e-15 1.223e-14 3.740e-01 0.70877
## Home_TeamREAL MADRID 1.229e-14 1.281e-14 9.600e-01 0.33722
## Home_TeamREAL SOCIEDAD 4.884e-17 1.168e-14 4.000e-03 0.99666
## Home_TeamSEVILLA FC 2.286e-15 1.186e-14 1.930e-01 0.84718
## Home_TeamVALENCIA 4.268e-15 1.164e-14 3.670e-01 0.71389
## Home_TeamVALLADOLID -5.953e-15 1.525e-14 -3.900e-01 0.69637
## Home_TeamVILLARREAL 4.532e-15 1.165e-14 3.890e-01 0.69733
## Away_TeamALMERÍA -3.538e-15 1.981e-14 -1.790e-01 0.85824
## Away_TeamATHLETIC -3.177e-14 1.147e-14 -2.771e+00 0.00564 **
## Away_TeamATLETICO MADRID -8.686e-16 1.160e-14 -7.500e-02 0.94033
## Away_TeamBARCELONA 1.005e-14 1.353e-14 7.420e-01 0.45787
## Away_TeamCELTA 4.682e-16 1.165e-14 4.000e-02 0.96796
## Away_TeamCÓRDOBA 6.019e-15 1.982e-14 3.040e-01 0.76139
## Away_TeamDEPORTIVO -7.317e-16 1.263e-14 -5.800e-02 0.95379
## Away_TeamEIBAR -3.252e-15 1.158e-14 -2.810e-01 0.77884
## Away_TeamELCHE 1.286e-14 1.981e-14 6.490e-01 0.51622
## Away_TeamESPANYOL 3.095e-15 1.133e-14 2.730e-01 0.78480
## Away_TeamGETAFE -2.544e-15 1.192e-14 -2.130e-01 0.83098
## Away_TeamGIJÓN -2.544e-15 1.528e-14 -1.670e-01 0.86774
## Away_TeamGIRONA 2.754e-15 1.514e-14 1.820e-01 0.85565
## Away_TeamGRANADA 2.812e-15 1.244e-14 2.260e-01 0.82118
## Away_TeamHUESCA -4.211e-15 1.938e-14 -2.170e-01 0.82801
## Away_TeamLAS PALMAS 8.474e-15 1.397e-14 6.070e-01 0.54422
## Away_TeamLEGANÉS -1.698e-15 1.233e-14 -1.380e-01 0.89047
## Away_TeamLEVANTE 6.854e-16 1.176e-14 5.800e-02 0.95351
## Away_TeamMÁLAGA -2.307e-16 1.258e-14 -1.800e-02 0.98537
## Away_TeamMALLORCA 1.503e-15 1.953e-14 7.700e-02 0.93866
## Away_TeamOSASUNA -4.290e-15 1.511e-14 -2.840e-01 0.77647
## Away_TeamRAYO VALLECANO 3.420e-15 1.383e-14 2.470e-01 0.80474
## Away_TeamREAL BETIS 8.013e-15 1.222e-14 6.560e-01 0.51200
## Away_TeamREAL MADRID 1.977e-15 1.261e-14 1.570e-01 0.87546
## Away_TeamREAL SOCIEDAD -1.587e-15 1.164e-14 -1.360e-01 0.89160
## Away_TeamSEVILLA FC 2.325e-15 1.165e-14 2.000e-01 0.84179
## Away_TeamVALENCIA 2.787e-15 1.157e-14 2.410e-01 0.80972
## Away_TeamVALLADOLID 3.643e-15 1.515e-14 2.400e-01 0.81001
## Away_TeamVILLARREAL 1.259e-16 1.156e-14 1.100e-02 0.99132
## `Home_Team_Possession_%` -5.458e-16 5.874e-16 -9.290e-01 0.35287
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots 5.194e-16 8.881e-15 5.800e-02 0.95337
## Home_Team_On_Target_Shots 1.182e-15 8.882e-15 1.330e-01 0.89412
## Home_Team_Total_Shots -8.296e-16 8.844e-15 -9.400e-02 0.92528
## Home_Team_Blocked_Shots -6.959e-17 8.856e-15 -8.000e-03 0.99373
## Home_Team_Corners 4.995e-17 7.303e-16 6.800e-02 0.94547
## Home_Team_Throw_Ins 4.980e-16 3.192e-16 1.560e+00 0.11889
## `Home_Team_Pass_Success_%` 5.894e-16 6.257e-16 9.420e-01 0.34632
## Home_Team_Aerials_Won 3.245e-17 3.323e-16 9.800e-02 0.92223
## Home_Team_Clearances 3.430e-16 2.831e-16 1.212e+00 0.22576
## Home_Team_Fouls 1.636e-16 4.651e-16 3.520e-01 0.72509
## Home_Team_Yellow_Cards 1.000e+00 1.194e-15 8.377e+14 < 2e-16 ***
## Home_Team_Second_Yellow_Cards 8.731e-17 6.811e-15 1.300e-02 0.98977
## Home_Team_Red_Cards -6.648e-14 7.388e-15 -8.999e+00 < 2e-16 ***
## Away_Team_Off_Target_Shots 7.694e-16 7.627e-15 1.010e-01 0.91966
## Away_Team_On_Target_Shots -7.360e-16 7.659e-15 -9.600e-02 0.92345
## Away_Team_Total_Shots -1.148e-16 7.601e-15 -1.500e-02 0.98795
## Away_Team_Blocked_Shots 5.295e-16 7.662e-15 6.900e-02 0.94491
## Away_Team_Corners 3.664e-16 7.991e-16 4.580e-01 0.64669
## Away_Team_Throw_Ins 1.768e-16 3.413e-16 5.180e-01 0.60436
## `Away_Team_Pass_Success_%` -7.188e-16 5.828e-16 -1.233e+00 0.21761
## Away_Team_Aerials_Won -1.078e-17 3.283e-16 -3.300e-02 0.97382
## Away_Team_Clearances 1.967e-16 2.606e-16 7.550e-01 0.45027
## Away_Team_Fouls 4.396e-16 4.600e-16 9.560e-01 0.33936
## Away_Team_Yellow_Cards 1.000e+00 1.214e-15 8.238e+14 < 2e-16 ***
## Away_Team_Second_Yellow_Cards 2.385e-15 5.877e-15 4.060e-01 0.68491
## Away_Team_Red_Cards 6.626e-15 7.237e-15 9.160e-01 0.35995
## Home_Team_Goals_Scored 1.783e-15 2.090e-15 8.530e-01 0.39370
## Away_Team_Goals_Scored 1.707e-15 2.361e-15 7.230e-01 0.46978
## year -4.864e-13 2.149e-13 -2.263e+00 0.02372 *
## resultado2 1.172e-14 7.447e-15 1.574e+00 0.11573
## resultadox 8.315e-15 5.247e-15 1.585e+00 0.11312
## goles NA NA NA NA
## total_disparos NA NA NA NA
## total_disparos_bloqueados NA NA NA NA
## total_corners NA NA NA NA
## total_centros NA NA NA NA
## total_d_aereos NA NA NA NA
## total_despejes NA NA NA NA
## total_faltas NA NA NA NA
## total_rojas NA NA NA NA
## Home_points NA NA NA NA
## Away_points NA NA NA NA
## jornada -1.258e-14 5.656e-15 -2.224e+00 0.02628 *
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 7.497e-14 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 2.286e+28 on 92 and 2187 DF, p-value: < 2.2e-16
lm_rojas <- lm(total_rojas~., data = train)
summary(lm_rojas)
##
## Call:
## lm(formula = total_rojas ~ ., data = train)
##
## Residuals:
## Min 1Q Median 3Q Max
## -3.830e-14 -1.270e-16 -1.900e-17 9.900e-17 7.668e-15
##
## Coefficients: (12 not defined because of singularities)
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) 1.363e-11 5.190e-12 2.626e+00 0.008689 **
## ...1 1.794e-17 6.781e-18 2.646e+00 0.008204 **
## Home_TeamALMERÍA 1.421e-17 2.377e-16 6.000e-02 0.952326
## Home_TeamATHLETIC -6.885e-18 1.374e-16 -5.000e-02 0.960039
## Home_TeamATLETICO MADRID 1.300e-16 1.390e-16 9.350e-01 0.349748
## Home_TeamBARCELONA 4.289e-16 1.616e-16 2.655e+00 0.007996 **
## Home_TeamCELTA 2.524e-18 1.415e-16 1.800e-02 0.985771
## Home_TeamCÓRDOBA 2.055e-16 2.379e-16 8.640e-01 0.387801
## Home_TeamDEPORTIVO -1.546e-16 1.509e-16 -1.024e+00 0.305895
## Home_TeamEIBAR -2.960e-16 1.401e-16 -2.113e+00 0.034698 *
## Home_TeamELCHE -9.340e-17 2.384e-16 -3.920e-01 0.695255
## Home_TeamESPANYOL -1.095e-16 1.360e-16 -8.050e-01 0.420694
## Home_TeamGETAFE -2.765e-17 1.432e-16 -1.930e-01 0.846907
## Home_TeamGIJÓN -6.294e-17 1.848e-16 -3.400e-01 0.733518
## Home_TeamGIRONA -1.129e-16 1.818e-16 -6.210e-01 0.534692
## Home_TeamGRANADA -1.694e-16 1.492e-16 -1.135e+00 0.256421
## Home_TeamHUESCA -2.120e-16 2.336e-16 -9.070e-01 0.364271
## Home_TeamLAS PALMAS 2.898e-17 1.703e-16 1.700e-01 0.864861
## Home_TeamLEGANÉS 4.467e-17 1.478e-16 3.020e-01 0.762576
## Home_TeamLEVANTE 7.530e-18 1.419e-16 5.300e-02 0.957688
## Home_TeamMÁLAGA -6.149e-16 1.506e-16 -4.082e+00 4.62e-05 ***
## Home_TeamMALLORCA -5.799e-16 2.345e-16 -2.473e+00 0.013474 *
## Home_TeamOSASUNA -3.582e-17 1.828e-16 -1.960e-01 0.844634
## Home_TeamRAYO VALLECANO 3.713e-17 1.657e-16 2.240e-01 0.822667
## Home_TeamREAL BETIS -2.032e-17 1.467e-16 -1.390e-01 0.889835
## Home_TeamREAL MADRID -1.111e-17 1.536e-16 -7.200e-02 0.942319
## Home_TeamREAL SOCIEDAD 3.759e-17 1.401e-16 2.680e-01 0.788459
## Home_TeamSEVILLA FC 5.898e-17 1.422e-16 4.150e-01 0.678401
## Home_TeamVALENCIA 6.072e-17 1.396e-16 4.350e-01 0.663584
## Home_TeamVALLADOLID -2.441e-16 1.829e-16 -1.335e+00 0.182136
## Home_TeamVILLARREAL -4.508e-18 1.397e-16 -3.200e-02 0.974264
## Away_TeamALMERÍA 3.662e-16 2.375e-16 1.542e+00 0.123295
## Away_TeamATHLETIC 3.890e-17 1.375e-16 2.830e-01 0.777303
## Away_TeamATLETICO MADRID 3.891e-16 1.391e-16 2.797e+00 0.005208 **
## Away_TeamBARCELONA 2.739e-16 1.622e-16 1.688e+00 0.091534 .
## Away_TeamCELTA 2.870e-16 1.398e-16 2.054e+00 0.040139 *
## Away_TeamCÓRDOBA 5.004e-16 2.377e-16 2.105e+00 0.035366 *
## Away_TeamDEPORTIVO 1.623e-16 1.514e-16 1.072e+00 0.283886
## Away_TeamEIBAR 1.251e-16 1.388e-16 9.010e-01 0.367500
## Away_TeamELCHE 9.939e-16 2.376e-16 4.183e+00 2.99e-05 ***
## Away_TeamESPANYOL 2.108e-16 1.359e-16 1.551e+00 0.120984
## Away_TeamGETAFE 2.790e-16 1.429e-16 1.952e+00 0.051026 .
## Away_TeamGIJÓN 5.070e-16 1.832e-16 2.767e+00 0.005698 **
## Away_TeamGIRONA 2.426e-16 1.815e-16 1.336e+00 0.181548
## Away_TeamGRANADA 3.596e-16 1.492e-16 2.411e+00 0.015986 *
## Away_TeamHUESCA 1.213e-16 2.324e-16 5.220e-01 0.601884
## Away_TeamLAS PALMAS 3.123e-16 1.675e-16 1.864e+00 0.062431 .
## Away_TeamLEGANÉS 3.064e-16 1.478e-16 2.073e+00 0.038298 *
## Away_TeamLEVANTE 2.529e-16 1.410e-16 1.794e+00 0.072944 .
## Away_TeamMÁLAGA 2.348e-16 1.508e-16 1.557e+00 0.119669
## Away_TeamMALLORCA 3.322e-16 2.342e-16 1.418e+00 0.156207
## Away_TeamOSASUNA 2.864e-16 1.812e-16 1.581e+00 0.114038
## Away_TeamRAYO VALLECANO 3.710e-16 1.658e-16 2.237e+00 0.025387 *
## Away_TeamREAL BETIS 3.955e-16 1.465e-16 2.700e+00 0.006993 **
## Away_TeamREAL MADRID 1.712e-16 1.513e-16 1.132e+00 0.257881
## Away_TeamREAL SOCIEDAD 2.628e-16 1.396e-16 1.882e+00 0.059906 .
## Away_TeamSEVILLA FC 3.274e-16 1.396e-16 2.344e+00 0.019142 *
## Away_TeamVALENCIA 1.758e-16 1.388e-16 1.267e+00 0.205292
## Away_TeamVALLADOLID 1.609e-16 1.817e-16 8.850e-01 0.376020
## Away_TeamVILLARREAL 2.999e-16 1.387e-16 2.163e+00 0.030645 *
## `Home_Team_Possession_%` -3.858e-18 7.044e-18 -5.480e-01 0.583990
## `Away_Team_Possession_%` NA NA NA NA
## Home_Team_Off_Target_Shots -3.205e-16 1.065e-16 -3.010e+00 0.002647 **
## Home_Team_On_Target_Shots -3.548e-16 1.065e-16 -3.331e+00 0.000879 ***
## Home_Team_Total_Shots 3.507e-16 1.061e-16 3.307e+00 0.000959 ***
## Home_Team_Blocked_Shots -3.625e-16 1.062e-16 -3.413e+00 0.000655 ***
## Home_Team_Corners 9.020e-18 8.757e-18 1.030e+00 0.303160
## Home_Team_Throw_Ins -7.873e-19 3.828e-18 -2.060e-01 0.837064
## `Home_Team_Pass_Success_%` 1.018e-18 7.503e-18 1.360e-01 0.892067
## Home_Team_Aerials_Won -1.118e-17 3.985e-18 -2.805e+00 0.005073 **
## Home_Team_Clearances 2.001e-18 3.394e-18 5.890e-01 0.555687
## Home_Team_Fouls 4.558e-18 5.578e-18 8.170e-01 0.413915
## Home_Team_Yellow_Cards -5.983e-18 1.431e-17 -4.180e-01 0.676030
## Home_Team_Second_Yellow_Cards -2.996e-17 8.168e-17 -3.670e-01 0.713800
## Home_Team_Red_Cards 1.000e+00 8.859e-17 1.129e+16 < 2e-16 ***
## Away_Team_Off_Target_Shots 1.254e-17 9.146e-17 1.370e-01 0.890968
## Away_Team_On_Target_Shots -5.487e-18 9.184e-17 -6.000e-02 0.952368
## Away_Team_Total_Shots -7.730e-18 9.115e-17 -8.500e-02 0.932429
## Away_Team_Blocked_Shots 9.257e-18 9.188e-17 1.010e-01 0.919760
## Away_Team_Corners 1.062e-17 9.583e-18 1.108e+00 0.268105
## Away_Team_Throw_Ins -1.340e-18 4.092e-18 -3.270e-01 0.743402
## `Away_Team_Pass_Success_%` -5.331e-18 6.989e-18 -7.630e-01 0.445699
## Away_Team_Aerials_Won 5.097e-18 3.937e-18 1.295e+00 0.195608
## Away_Team_Clearances -4.626e-19 3.125e-18 -1.480e-01 0.882325
## Away_Team_Fouls 5.493e-18 5.516e-18 9.960e-01 0.319424
## Away_Team_Yellow_Cards 1.034e-17 1.456e-17 7.100e-01 0.477659
## Away_Team_Second_Yellow_Cards 8.658e-18 7.048e-17 1.230e-01 0.902243
## Away_Team_Red_Cards 1.000e+00 8.678e-17 1.152e+16 < 2e-16 ***
## Home_Team_Goals_Scored 3.031e-17 2.506e-17 1.210e+00 0.226595
## Away_Team_Goals_Scored 1.040e-17 2.831e-17 3.670e-01 0.713442
## year -6.769e-15 2.577e-15 -2.627e+00 0.008684 **
## resultado2 1.580e-16 8.930e-17 1.770e+00 0.076931 .
## resultadox 1.086e-16 6.291e-17 1.726e+00 0.084484 .
## goles NA NA NA NA
## total_disparos NA NA NA NA
## total_disparos_bloqueados NA NA NA NA
## total_corners NA NA NA NA
## total_centros NA NA NA NA
## total_d_aereos NA NA NA NA
## total_despejes NA NA NA NA
## total_faltas NA NA NA NA
## total_amarillas NA NA NA NA
## Home_points NA NA NA NA
## Away_points NA NA NA NA
## jornada -1.768e-16 6.783e-17 -2.607e+00 0.009189 **
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 8.99e-16 on 2187 degrees of freedom
## Multiple R-squared: 1, Adjusted R-squared: 1
## F-statistic: 3.238e+30 on 92 and 2187 DF, p-value: < 2.2e-16
REGRESION BACKWARD
# CONCLUSIONES Hay muchas variables que no afectan al resultado de un
partido.
Los equipos locales ganan más.
Hay dos equipos que sobresalen (Madrid y Barsa)
Hay un grupo de equipos “buenos” (nunca han descendido, meten más
goles…)
De cara al futuro:
Cuanto se parecen dos partidos?
Clusterizar equipos en buenos, medios y malos.
Incluir las rachas de victorias, dorrotas y empates.
Calcular los puntos que suma cada equipo por partido en función de ser
local o visitante, del “nivel” del rival, etc.
Predecir el número de goles que va a marcar cada equipo en un partido,
en vez de victoria/derrota/empate.